I have noticed a strange problem with SQL 2008 R2 that I can't account for. When I run a specific query on the physical sql server in question it takes about 60 seconds to run. It also takes around 60 seconds on remote windows 2008 r2 servers that have SSMS, but when I run this query from a windows 2003 server with SSMS, the query is about 20 seconds faster to return. I can't think of any reason to explain this behavior but I can replicate it over and over. Any 2003 server returns the query faster than any 2008 r2 server or even the actual sql server itself. Any ideas? Thanks.