Posts
1150
Comments
891
Trackbacks
1
SQL Query Troubleshooting Tip #1

If a query that has been running without a hitch suddenly crawls to a standstill for no apparent reason, try updating statistics.

In SQL Server, run sp_updatestats.

And if you are experienced with SQL Server, think of trying tip #1 first, not four hours later.

posted on Wednesday, July 20, 2011 7:08 PM Print
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 8 and 8 and type the answer here: