While many indexing best practices continue from SQL Server 2000, there are some new indexing features in SQL Server 2005 which you should be aware of.

In this session, we first discuss how to design efficient and maintainable clustered and non-clustered indexes before drilling into the importance of query tuning with non-clustered covering indexes. In the remainder of the session, we'll discuss SQL Server 2005's new indexing options including Online indexing, Included Columns, Index Management Views and Disabled Indexes. If you want to learn how to design optimal table structures, achieve better data availability as well as indexing for performance, this is a session for you

Available as a Web Cast at:

http://msevents-as.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=120465372&EventCategory=3&culture=en-AU&CountryCode=AU

Venue: SA Innovation Centre, L2 Santos House

Duration 12:00-14:00 (lunch 12:00-12:30, session starts at 12:30, with a few

minutes house-keeping notices beforehand)

Date: Thursday, 10 November 2005