Event link at our Meetup page.
- 5:30 Networking
- 6:00 Meeting
An introduction to SQL Server Indexes and Statistics
One of the most amazing features of SQL Server is how flexible it just works 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 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.
David Klee
David Klee is a Microsoft MVP and VMware vExpert with a passion for the convergence of data, cloud, and infrastructure. 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 virtualization and performance, datacenter 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.
David speaks at a number of national and regional technology related events, including the PASS Summit, VMworld, IT/Dev Connections, SQL Saturday events, SQL Cruise, PASS virtual chapter webinars, and many SQL Server User Groups.
