Event link at our Meetup page.

• 5:30 Networking
• 6:00 Meeting

SQL Server Indexes and Statistics: From Theory to Practice

Part 2 of last month’s presentation

SQL Server’s query optimizer can produce excellent plans (most of the time), but only when it has the right metadata – via indexes and statistics. This session moves beyond the basics and gives databases developers and performance tuners the concrete techniques they need to audit, design, and maintain indexes underneath critical business-critical databases. Even modest adjustments can cut query runtimes by significant amounts without touching application code. Come prepared and leave with a toolbox that turns “indexing is an art” into a repeatable science!

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.

---