SQL Server performance and statistics

May 22, 2009

Filed under: Uncategorized — zootfroot @ 9:43 am

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.

Be the first to like this post.

No comments yet.

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Connecting to %s