RE: Auto update stats not good enough

SSC Guru

Points: 323504

October 5, 2009 at 11:59 am

#1061913

ouch that sysindexes is handy and i haven't found any view that still tracks that [rows] and [rowmodctr] yet.

GilaMonster (10/5/2009)
Just bear in mind that sysindexes is deprecated, will be removed in a future version of SQL server and that the rowmodcol is not longer 'accurate'. It's a calculation based off the hidden column modification counters that are in one of the system tables.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!