Description:

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.