3 Ways to Destroy SQL Performance (and how to fix it)

In this video, we talk about SQL indexes. We discuss the internal representation of heap tables and B-trees and understand how indexes are used to speedup search within the table.

We solidify our understanding with several hands-on examples, reviewing the execution plans within SQL Server, and understanding how to spot performance problems by using execution plans.

Finally, we learn about 3 common pitfalls that prevent your query from running with maximum performance and talk about how to fix those.

0:00 - Intro
1:05 - Introduction to Indexes
7:30 - Indexes in SQL Server
16:35 - Functions & Indexes: Pitfall # 1
19:30 - Column Ordering: Pitfall # 2
22:42 - LIKE operator: Pitfall # 3

Видео 3 Ways to Destroy SQL Performance (and how to fix it) канала MeDoThings