Indexes Basically
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.
Speaker focus
aka GrumpyOldDBA www.grumpyolddba.co.uk. Worked with SQL Server since 6.0 Production DBA who tends to specialise in server and application performance tuning.
Other sessions from this conference