|
Video Description
In this video you will learn how to manage your indexes in SQL Server 2008. You will learn about index fragmentation including page splits and forwarding pointers. You will learn how to query sys.dm_db_index_physical_stats to determine if your index is fragmented and how to defragment your index using REBUILD or REORGANIZE. You will also learn how to use FILLFACTOR and PADINDEX to reduce index fragmentation.
Total Time: 14 Minutes 28 Seconds Video: 12 of 14
|