• Actually the table is over 100GB in size just data not counting indexes. This is a very large database (5TB) and the servers are very powerful with over 128GB ram ect. The query selects top 10000 records ordered by recordate. It is slow even with top 20 on the new server. It was intended as a test of tempdb for sure but certainly shouldn't have caused these types of issues.

    I was a little wary of posting too much information due to security around here, let me check with my boss and if it is ok to post the information you suggested.

    BTW thanks for your response and I appropriate any help very much!

    I don't always test my SQL scripts, but when I do, I test in Production.