Simon's SQL

SQL,DBA,tuning,Trouble Shooting,Performance

«
»

Index rebuild vs. Statistics update

Posted by Simon Cho on 04/11/2012

http://sqlserverpedia.com/blog/sql-server-bloggers/update-statistics-before-or-after-an-index-rebuild/

http://www.sqlskills.com/blogs/paul/post/Search-Engine-QA-10-Rebuilding-Indexes-and-Updating-Statistics.aspx

Another good article.
http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

Advertisements

This entry was posted on 04/11/2012 at 7:07 PM and is filed under Common. Tagged: , . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

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

Gravatar
WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Cancel

Connecting to %s

«
»
 
%d bloggers like this: