Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

sp_updatestats and the default sampling rate Expand / Collapse
Posted Thursday, March 21, 2013 9:23 AM



Group: Administrators
Last Login: Today @ 7:34 AM
Points: 31,665, Visits: 16,117
One more thing to keep in mind, you may have statistics on columns that are not in indexes. Make sure those are being updated. Your plan could potentially skip these statistics.

I agree with Igor's post. Here's some info on the trace flag:

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1433861
Posted Thursday, March 21, 2013 3:33 PM


Group: General Forum Members
Last Login: Wednesday, December 18, 2013 6:45 PM
Points: 17, Visits: 108
Thanks Guys for your input,
can you please elaborate on ...if you do REORGANIZE on big indexes and then update their stats, then you'd better check the time for only REBUILD them regardless they have #frag<30%

Post #1434059
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse