Posts by Brent Ozar

Cool Query Hints

T-SQL
14 Comments
The SQL Server documentation has a pretty cool list of query hints: Yeah, I surf in dark mode. I’m a dark kinda guy. But wait – what’s that colored box? ENHANCE! I could make jokes here, but … every single thing in that caution is true. SQL Server really does typically select the best execution…
Read More

Performance Tuning Means 3 Things

Managing what requests are made Managing the efficiency of each request Managing the hardware capacity available to satisfy requests And that’s it. In the grand scheme of things, those are the only 3 knobs you get. Oh sure, from the outside, performance tuning looks more complicated than that, but at the end of the day,…
Read More
Portrait in T-SQL

My 11 Favorite 2019 Blog Posts

Company News
4 Comments
Yesterday, I showed the stuff you read the most, but enough data – now, let’s talk about feelings. These were the 11 posts I remember with the most fondness, in date order. I did indeed like some of the ones from yesterday’s list a lot, but I’m going to set those aside. Erik and Tara…
Read More
Big tequila

Your Ten Favorite Blog Posts from 2019

Company News
2 Comments
Here are the 2019 posts you visited the most this year: 10. The Silent Bug I Find in Most Triggers – Once you know how to recognize this bug, you’ll see it everywhere. I wrote the post as an interactive Azure Data Studio notebook, something I thought I’d be doing a lot in 2019, but…
Read More
Mastering Index Tuning

Join Me in London for My SQLBits Pre-Con Workshop: Mastering Index Tuning

I’m teaching an all-new hands-on workshop, Mastering Index Tuning. I’m taking my favorite, toughest modules of my 3-day online class and condensing them down into a 1-day workshop. You’ll learn quick, easy techniques to use the right nonclustered indexes, filtered indexes, indexed views, and columnstore indexes that will work on SQL Server 2019, 2017, 2016,…
Read More