Session Details

Indexes: The Voodoo of SQL Server

Regular Session

Microsoft SQL Server is a large data ecosystem with many facets that can affect how your queries perform. Facets like what kind of hardware are you using, how much memory, CPUs. Many of these facets cost money and there are many things about them that can be turned on, tweaked, or implemented to help improve performance. Did you know that you can implement a low-cost solution of proper indexing? Proper indexes can help not only improve query performance but also help save money on hardware! In this session we'll examine the foundation of how indexes work, what the moving parts are and why they are important. We'll examine some real-world examples of where queries were falling short but then were successful with proper indexing. You'll walk away with techniques on how to know where and how to add indexes to help you start to save money!
About

A software development conference in the Louisville, KY area on August 19 - 21, 2020 designed to cover all aspects of software development regardless of development stack.

Keep in Touch