aravind (2/24/2009)
Normally 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".
More users and hence more load on production. More data on production. Older statistics. More fragmented indexes. Different exec plan.
Lots of reasons
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability