As for your first question, it is quite an interesting one to check. I think, If you have just date with no time your index on that column wont be...

Check your remote query timeout. I sometimes get that error in Management studio connecting to my Server. It could be that. Change it on SP_Configure

There are several ways to do it, but for the record, this is awsome interview question, removing duplicates has the ability to baffle many people.

Are you able to re-create this scenario with data in temporary tables. It would be cool to get to the bottom of this. Please post an example for us to...

Maybe I have misunderstood. But wouldn't select * from T1 do the trick. Not that you should use select * but maybe I have misunderstood the post.

Crisis, this is getting confusing, yet inspires me to go and find more of these wierd, but usefull, functions. Thanks for the insight guys.

SELECT EXP(SUM(LOG(SID))) FROM #t

I don't understand how this actually works. We getting the float value of all the numbers and then converting it into an exponential value. Sorry guys, looks...

Did you ever solve this. I am trying to conditionally send through an all parameter to a drill through report in a matrix and this hidden visible thing seems like...

I think this is a briliant article, thanks for this Steven. It seems to be a problem in the industry at the moment. I recently also read an article entitled...