This SQL Server Index Maintenance Overview contains the following 3 topics: Determining Index Fragmentation with DBCC SHOWCONTIG
Fixing Fragmented Indexes
Distribution Statistics Determining Inde...
Ever wonder how to tell what columns would be good for indexes? Once the index is created, ever wonder why you never see it in SQL explain plans you would expect to see it in??? There are 2 useful st...
