InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 06:33:29 GMT20http://www.sqlservercentral.com/Forums/Topic769344-360-1.aspxTOP 5000000? That's an aweful lot of rows to be 'limiting' a result set to. What's the purpose of that TOP clause?Wed, 12 Aug 2009 09:33:24 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic769344-360-1.aspxPlease read the second article in my signature block regarding asking for assistance on performance problems. Based on your post, there really isn't much we can do to help you.Wed, 12 Aug 2009 08:34:40 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic769344-360-1.aspxCan anybody help me in trying to resolve the performance issue in a simple sql using "select top 5000000 " with order by clause in sql server 2005? It ran 2 secs in development database but ran 12 mins or more in production datable using the exact sql. However, if I reduce the select top value from 5000000 to 50000, it ran about 4 secs. Regardless, can anyone give me a clue why the exact sql performance timing is different? I am new sql server database...are there database parameters setting the DBA need to be look at? Any help is much appreciated. Thank you.Wed, 12 Aug 2009 08:21:08 GMTricky.wong