MSSQLWIKI

Karthick P.K on SQL Server

«
»

How to rebuild index and update statistics for all the tables in database.

Posted by Karthick P.K on September 26, 2010

 
EXEC sp_MSforeachtable 'UPDATE STATISTICS ? WITH FULLSCAN'   --  {can be run anytime}

Exec sp_MSforeachtable "dbcc dbreindex('?')"      --- {Always run this on a off-peak hour on any SQL Server instance}
 



Thanks


Karthick

This entry was posted on September 26, 2010 at 1:57 PM and is filed under Optimizer, Performance, SQL General, SQL Query. 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.

3 Responses to “How to rebuild index and update statistics for all the tables in database.”

  1. Top SQL Server blogs from MSSQLWIKI « MSSQLWIKI said

    January 11, 2014 at 12:57 PM

    […] How to rebuild index and update statistics for all the tables in database. […]

    Reply

  2. saravana said

    September 15, 2014 at 6:05 PM

    Hi Karthick,

    Thanks for the post. i am a new bee sql server admin. When i try to update statistics for the db, the server hangs. So try to update part by part and i found that it is getting stuck in few tables. So i excluded those tables and try to update, it worked. I try to manually update those tables (which hanged), it hangs. Is there any way i can update statistics in those tables?

    Reply

  3. itats said

    October 17, 2014 at 3:33 AM

    It’s difficult to find experienced people about this subject,
    but you sound like you know what you’re talking
    about! Thanks

    Reply

Leave a comment

«
»