That's right. I forgot about the leaf level. If I plan on performing ONLINE reindexing then I will need to modify my code to check for LOB_DATA, but...

Can you help me understand why two rows are returned from DM_DB_INDEX_PHYSICAL_STATS where both rows have the same object_id and

_id (1), but alloc_unit_type_desc is LOB_DATA for one row and...

Sorry. I misread your previous heap post. I believe in the case of Update Statistics you still run it against a heap because column statistics are updated. ...

Thanks Gail. Do they recommend rebuilding a HEAP in 2005 so the table stats get updated or is something else being done to the HEAP?

I just found some articles by Kalen. She describes Internal and External fragmentation better then I can. Unfortunately I now need to update our 2005 defragmentation scripts based...

We have logic for partitions and for page length, but nothing for online rebuilds. I just began experimenting with online rebuilds yesterday and was surprised by how well it...

I think people use different terms for external fragmentation. It occurs when extents are not contiguous. Check out these links for a better explanation.

You may not be able...

I proposed that to the vendor this morning along with only turning off Auto Update / Create on a handful of very large tables. I also pointed out to...

This Microsoft comment pertained to 2000. I'm not sure if it also works with 2005.

It is also possible to enable trace flag 8721, which will dump information into the...

I'm going to turn it on, but before I do so there is a Trace flag I am trying to find that will log everytime Auto Update runs (I believe).

Another...

Looks like I'm basically out of luck with trying to determine when statistics need updating. I'll give up on that process and turn my attention to determining why Update...

Thanks George. I'll give it a try.

sys.dm_db_index_usage_stats. I knew there had to be a DMV out there somewhere that contained index information. I can use that along with the following rule referenced by you...

I prefer to keep it turned on and have done so with all systems I support, but when a large vendor tells us to turn it off and we do...

We have auto_update_statistics and auto_create_statistics turned off as a vendor requirement. We have to update them manually. For this reason I need to determine how to know when...