Click here to monitor SSC
SQLServerCentral is supported by Redgate
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 @ 12:35 PM
Points: 34,363, Visits: 18,578
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
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 6:21 PM
Points: 30, Visits: 152
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