The Ins and Outs of SQL Indexes

The Ins and Outs of SQL Indexes

Speaker: MINDY CURNUTT 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....
7 Things to Know About Wait Stats

7 Things to Know About Wait Stats

Speaker: STEVE STEDMAN 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...