Web Cast: How to design efficient and maintainable clustered and non-clustered indexes with Greg Linwood


 

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


Comments (0)