In terms of nights Tuesday, Skint as mentioned or Wednesday, which is when all of the Sports Teams have their games and all are sponsored to go out drinking afterwards, I know Liquid is where most of the Abertay lot go.
Note that I'm definitely replying in terms of busiest, not best.