In this session we will be looking at the best and worse practices for indexing tables within your SQL Server 2000-2012 databases. We will also be looking into the new indexing features that are available in SQL Server 2012 (and SQL Server 2005/2008) and how you the .NET developer can make the best use of them to get your code running its best.
- Learn why indexes need to be created
- Learn how indexes can help your databases performance
- Learn how indexes can hurt your databases performance
Denny Cherry is the owner and principal consultant for Denny Cherry & Associates Consulting and has over a decade of experience working with platforms such as Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2008, including the MCM and MVP.