InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 07:17:48 GMT20http://www.sqlservercentral.com/Forums/Topic664035-65-1.aspxDuplicate post. No replies to this thread please. Direct replies to:[url]http://www.sqlservercentral.com/Forums/Topic664033-65-1.aspx[/url]Wed, 25 Feb 2009 00:17:35 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic664035-65-1.aspxHi,I have a select query from a table which has a column with huge data. The select query takes 14 secs in the development server but the same query takes 70 secs in the production server.To simulate the issue, I created the following script and tested in both the environmentscreate table Testperf(col1 varchar(5000) )declare @i intselect @i = 1while @i <= 1000begininsert into Testperfselect replicate('Bravo',600)set @i = @i + 1endselect * from TestperfNormally any company will have production server highly configured than the development server. So in that case how this could happen?"Production server slower than development server".Tue, 24 Feb 2009 23:54:30 GMTaravind-305595