Skip to content

Instantly share code, notes, and snippets.

@airtank20

airtank20/Indexes: The Voodoo of SQL Server.md

Created March 6, 2020 01:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save airtank20/0bc0d6d58915f1bbcf8b1667b3f1c5da to your computer and use it in GitHub Desktop.
Save airtank20/0bc0d6d58915f1bbcf8b1667b3f1c5da to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Indexes: The Voodoo of SQL Server.md

Indexes: The Voodoo of SQL Server

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!
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment