sql server, table, extent - SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)

DBCC EXTENTINFO - unused pages in these extents (undocumented) Published 4 September 7 7:45 AM | SSQA.net: When it comes to resolving table fragmentation, the basic checkout you perform is to run DBCC INDEXDEFRAG or even run DBCC DBREINDEX statements. As per the default configuraiton SQL Database Engine allocates a new extent to an allocation unit only when...

Filed under: sql server, performance, indexes, data, i/o, table, insert, allocation, fragmentation, deadlock, extent

SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)