By the time I got to the point where you let us in on the joke, I was already planning an email to my teammates to say WTH ... we...

Physical fragmentation hurts sequential file IO signficantly. However; almost all IO operations on SQL data files are nonsequential reads or writes. That means that the head is going to have...

I answered the last question without thinking of the context of the article. The query I gave is all about whether statistics are set to autoupdate, and last time they...

sbatemen, is this what you are looking for?

SELECT

[schema name]= SCHEMA_NAME(o.schema_id)

,[object name]= OBJECT_NAME(s.object_id)

,[stats name]= s.name

,[auto created?]= CASE s.auto_created WHEN 1 THEN 'yes' ELSE 'no' END

,[no recompute?]= case s.no_recompute WHEN 1...

YeshuaAgapao, I have to disagree with you on rebuild using a resample to update statistics. It definitely uses a fullsample. Here is an example I just did on a test...

just to quibble with words a little bit: sp_updatestats only checks to see if rowmodctr is 0 or not. If it is not 0, it updates stats. That's a little...