statistics update

• Tara-1044200

  SSCoach

  Points: 15951

  More actions

  September 16, 2010 at 11:55 am

  #140665

  I am updating statistics foe some tables in a database, how do i find what is the % of updates are completed so far and is there a way to update statistics by column instead of table.

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  September 16, 2010 at 12:19 pm

  #1222478

  EXEC sp_updatestats gives more detailed messaging and also kind of how far the update completed as of now. But this updates all tables within a db.

  On the Other Hand you an use UPDATE STATISTICS to update only the columns within the table.

  UPDATE STATISTICS Sales.SalesOrderDetail WITH COLUMNS;

  But is doesn't give any status messages.

  Thank You,

  Best Regards,

  SQLBuddy