The Perfect Index by Arthur Daniels

GroupBy – Free SQL Server Training by Brent Ozar

Sep 25, 201801:03:43Technology

Creating indexes is one of the most powerful ways to improve performance in your SQL Servers. It's not easy to form indexes for a large and complicated query, and things only get more complicated when queries can come fr...

Related Episodes

Continue listening to more episodes from GroupBy – Free SQL Server Training.

Using Open Source Products to Collect Performance Metrics by Tracy Boggiano

Feb 12, 2019 - 56:55

Ever had a manager standing over your shoulder, wanting to know why an instance is running slow or if it...

Columnstore Indexes: What are waiting for? by Niko Neugebauer

Feb 5, 2019 - 01:18:35

Every time you see a Columnstore Index getting involved in the execution plan, do you realize that there...

The Problems With Optional Operators by Erik Darling and Joe Obbish

Jan 29, 2019 - 01:02:24

The optimizer has options. Not every option is optimal. Optimistic query tuners hope that the optimizer w...

How to get your dream job: Resume & job hunting tips by Andy Mallon

Jan 22, 2019 - 52:59

What do you want to be when you grow up? I want to be a DBA, a teacher, a blogger, and a world-traveler....

What 'Digital Transformation' Means, and How You Can Use It to Advance Your Career by Kendra Little

Jan 15, 2019 - 59:06

Whether you love or hate buzzwords, the big ones signify critical cultural changes. In this session, Kend...

New Engine Features in SQL Server 2019 by Aaron Bertrand

Jan 8, 2019 - 54:09

A new release of SQL Server is like a new season of your favorite TV show. Some releases in the past were...

An Introduction to Partitioning by DBAfromthecold

Oct 23, 2018 - 57:05

This mainly demo-based session will cover the following: An introduction to partitioning, core concepts,...

Make Your Own SQL Server Queries Go Faster by John Sterrett

Oct 16, 2018 - 01:03:28

Have you ever developed slowly running queries and wondered how to make your own SQL Server queries go fa...