Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Transact-SQL (2008)  Slow Union Sql 2008 R2

Author  Topic  Hus Starting Member 4 Posts Posted - 2011-08-14 : 07:30:05 I have upgraded to SQL 2008 R2 and windows 2008 R2 (64Bit) from SQL 2005and Windows 2003(32bit), both on VMware. I have long query which uses UNION. The query runs in SQL 2005(3 minutes) and SQL 2008 R2 (over 12 hours). I have enabled the Lock Pages in Memory Option, no different. The query Plan is same on both servers. Anyone have any ideas?