Thank you for your insights.

Maybe I am confused.

I thought the difference between Mixed and Uniform Extents was that

Uniform: All pages from the same object

Mixed: Pages from different objects

Your definition is

Uniform:...

Thanks

Yes, I use DBATools for most of my day to day things as it is.

I was just looking for a complete T-SQL script.

Thanks

Thanks

I have been using DBATools for...

Also....

sp_autostats table_name

I'm trying to get a flow of exactly what happens.

Am I on the right track here.....

• Page brought into buffer cache.
• Page modified and marked as dirty.
• Record of change...

(6) Yes.  Yes, potentially.  More likely it has not written either but it still allows the transaction to finish.  You get more speed and throughput but at a...

Thanks

(3) Data in memory (in a buffer) that is forcibly written to disk is said to be "flushed".  This does not mean any type of problem/error has occurred.  SQL...

Thanks

I had a look at the XML of the problematic report and I cannot see anything obvious. My knowledge of developing reports is very limited though.

I took the ReportServer &...

You got it. sp_updatestats uses a sample method instead of full scan. It means it's faster, but it's less accurate. There's always a tradeoff deciding which to use, so...

Fragmentation and statistics are two completely different, though somewhat related, things.

Fragmentation is simply about storage on the system. A page gets allocated to an index. Data gets put into...

Thank you

Great, thanks

Thanks, they're huge files

I tried changing to BIGINT but same error

I've narrowed it down to this statement...

exec sp_msforeachdb 
'use [?]; 
  select DB_NAME() AS DbName, 
    CONVERT(varchar(20),DatabasePropertyEx(''?'',''Status'')) ,  
   ...

Thanks

I hope I'm not missing something here because I really want to pursue this in our organization.

Are you aware of any edition limitations?