SQL Server Performance Tuning and Optimization

SQW04 Table Indexing


9:30am - 10:45am

Level: Intermediate

Denny Cherry

Owner and Principal Consultant

Denny Cherry & Associates Consulting

In this session, we'll look at the best and worst practices for indexing tables within your SQL Server 2000-2016 databases. We'll also look into the new indexing features that are available in SQL Server 2012/2014/2016 (and SQL Server 2005/2008) and how the .NET developer can make the best use of them to get their code running its best.

You will learn:

  • Clustered indexes
  • NonClustered indexes
  • Full Text indexes