PERFORMANCE
TUNING

The Ins and Outs of SQL Indexes


This session focuses on the fundamentals of SQL Server index design and creation. Terms that will be covered and clarified: clustered index, non-clustered index, uniqueness, covering index, fill-factor, scan, seek, key lookup, and fragmentation. This is the session for all those who have always found indexes confusing and somewhat elusive. We will use many analogies you are familiar with to describe index organization and give you the ability to identify when an index will help your query.

MINDY CURNUTT
MINDY CURNUTT
Microsoft MVP
Mindy Curnutt is a 3X Microsoft MVP as well as has been designated as a Trimble Distinguished Engineer.
STEVE STEDMAN
STEVE STEDMAN
Lead Technology Partner

Steve Stedman is a partner at SQL Data Partners and has been using SQL since 1990, having 25 years of SQL and database experience. This experience combined with experience on the latest and greatest SQL Server technologies comes together to offer clients services, products and training in a specific focus on SQL Server and SQL Server technologies. Steve is an avid participant in SQL PASS events like SQL Saturday, PAS Summit, and local PASS Chapters.

7 THINGS TO KNOW ABOUT WAIT STATS


Can we have a conference without a discussion on performance tuning?

Wait statistics are one of commonly overlooked ways to quickly find out what is causing your SQL Server to be slow. One of the reasons that they are commonly overlooked is that without a monitoring tool, or your own custom monitoring tools, it is difficult to see how they are trending over time.

When someone reports that the database was slow yesterday at 2:00pm, do you know how to determine what was causing it to be slow? You can check the logs, you can look at the history of running jobs, and you might even ask around to see if anyone was doing anything unusual at that time. If you are tracking wait statistics, it is quick and easy to zoom in on a point in time and see exactly what queries were slow and why they were slow. This session will guide you through the process of monitoring and responding to SQL Server waits.

What I will take home: A tool with the ability to capture waits and provide better information to your organization.