About this Event
Abstract
Introduction to SQL Server Indexes and Statistics
One of the most amazing features of SQL Server is how flexible it is with your queries. One of the most challenging features of SQL Server is that it lets you run just about anything, regardless of efficient query or underlying table structure. Database indexing can tune the SQL Server engine to more closely align with how your organization uses the database. It is as much an art as it is a science, but come to learn how to learn the science of how to measure and monitor index usage patterns so you can become a SQL Server indexing master and learn how to make your applications run faster with little to no query or code changes. With a free script and software package, we will learn how to learn how to find the higher consumers and review a query’s execution plan to hunt for inefficiencies.
Speaker Bio
David Klee is a Microsoft MVP and VMware vExpert with a passion for the convergence of infrastructure, cloud, and database technologies. David spends his days handling performance and HA/DR architecture of mission-critical SQL Servers as the Founder of Heraflux Technologies. His areas of expertise are cloud/virtualization and performance, data center architecture, and risk mitigation through high availability and disaster recovery. You can read his blog at davidklee.net, and reach him on Twitter at @kleegeek.
Event Venue
Online
USD 0.00
