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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by
on
Tue, Sep 4 2007
Filed under:
Filed under: sql server, performance, indexes, data, i/o, table, insert, allocation, fragmentation, deadlock, extent