About the Talk
September 2, 2009 6:00 AM
Ever wondered what makes an index effective? Curious about why the optimizer picks the indexes that it does?
In this session, we'll look at design considerations for clustered and non-clustered indexes as well as examine exactly what makes an index useful to SQL Server. We'll also take a look at the new SQL Server 2008 filtered indexes.