22 May 2009

SQL Server performance and statistics

Queries started running slowly on your SQL Server? Maybe your db statistics need updating.

A quick and dirty way to do this for all tables in your DB is the sp_updatestats sproc.

No comments:

Post a Comment

Comments are very welcome unless you're a spammer, in which case you should probably kill yourself.

If I helped you out today, you can buy me a beer below. Cheers!