As a DBA one of the tools of tuning that I use is effective indexing; This is a walk through on the basics of indexing from a performance point of view, this isn't best practice or text book solutions, this is based around hard pratical experience. This session will also cover the new index features of SQL2008 which in effect allow you to create partitioned indexes on a non partitioned table. Also covered will be some of the myths surrounding index performance degredation and why and for whom we actually create indexes.
WMV Video 184 MB