Platinum Sponsors
 

13th September 2008 Hatfield, Hertfordshire

Skip Navigation Links
RSS
Login or Join
Skip Navigation Links

Session Details - 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.
Colin Leversuch-Roberts
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.

To view the presentation below in full screen double click on it.


Click here to view in local media player

Due to the size of these files we can only provided streamed versions.

Other sessions from this conference

A Testing Time... (Downloads) (Video)
A walk down memory lane (Downloads) (Video)
Advanced T-SQL (2005 and 2008) (Downloads) (Video)
Choices, Choices - Loading and Modelling Slowly Changing Dimensions in the SQL Server 2008 Suite (Downloads) (Video)
Data Vizualisation - Make your reports useful to business - No more "Speed Dials" (Downloads) (Video)
Does your cube support your users reporting needs? (Downloads) (Video)
Don't try this at work ! (Downloads) (Video)
End to End Report Creation and Management using Microsoft SQL Server 2008 (Downloads) (Video)
Getting more value from your data through data mining. (Downloads) (Video)
Head in the Cloud... (Downloads) (Video)
How to approach zero downtime database upgrades (Downloads) (Video)
Microsoft's integrated end-to-end BI offering. (Downloads) (Video)
Performance Monitoring Using SQL Server Management Studio - power of Management Data Warehouse (Downloads) (Video)
Small Problem - Simple Solution: Lookup Tables (Downloads) (Video)
SQL Server – Under New Management (Downloads) (Video)
SQL Server 2008 for Developers (Downloads) (Video)
Understanding Query Cache and Query Plans (Downloads) (Video)
Useful Sql'y stuff that I've picked up over the years (Downloads) (Video)
Where’s my data? An introduction to Spatial Queries in SQL Server 2008 (Downloads) (Video)