In this session, we will be looking at the best and worst practices for indexing tables within your SQL Server 2000-2017 databases. We will also be looking into the new indexing features that are available in SQL Server 2012/-2025 (and SQL Server 2005/2008) and how you, the .NET developer, can make the best use of them to get your applications running their best.

You will learn:

• Performance improvements in databases
• Why databases need index tuning
• How to properly use non-clustered indexes