How to Improve SQL Server Performance with Indexing
Indexing presents daunting challenges for even the most seasoned professionals, as it offers countless options to choose from. With a little help you’ll see how to simplify indexing in your environment and improve
the overall performance of your SQL Server applications. In this session you will learn all about the different architectures of indexes, from that how to make the right choices when designing your indexes so that both the database engine and your DBA will love you for it. The session will also cover how to find missing and unused indexes, the cause and how to resolve fragmentation issues as well as how to maintain your indexes after they have been deployed.
After attending this session you will have a much better understanding of how to create the right indexes for your entire environment, not just for that one troublesome query.
Sorry, there are no downloads available for this session.
Richard Douglas is a Systems Consultant and SQL Server Evangelist for Dell Software where he specialises in providing SQL Server solutions and system health checks to organisations across the EMEA region. Richard is the founder and organiser of the Maidenhead SQL Server User Group and has spoken at several PASS events including the PASS Summit, SQL Rally's and SQL Saturdays. Richard also regularly presents webinars for Dell Software and PASS Virtual Chapters on various SQL Server related topics and was a technical reviewer on two SQL Server 2012 books.
Richard can be contacted via Twitter @SQLRich or on his blog http://SQL.RichardDouglas.co.uk
The video is not available to view online.