Watch Brent Tune Queries 2020

Thank you for providing the free first responder kit. Awesome!

Didactically one of the best summary in the short time.
I already know the trick with the calculated column, but just the overview of how to read the plan and correctly estimate the individual operator costs is worth its weight in gold. Thank you very much!

Very interesting the trick of adding a computed column to let the Query Optimizer use his statistic. Good job, Brent!

Awesome! I love how you thinking out loud while tuning!!!

can i get the database , Bret

Thank you Brent for everything you do for SQL DBA community..You are making a big difference..

This one was intense.. I took a lot of notes. Need a beer now, thanks Brent!

Loved your presentation, Awesome ☺☺ Thank you

Very good video, thanks. I've taken a step up in my skills and knowledge with all you have taught me. Made a slow query run in 160 ms instead of originals 38 seconds today. The satisfaction 💪😁.

Hey brent this was a great class, the computed column stuff was brilliant. Thanks very much

Loved that video. Fantastic explanation.

Fantastic to see your thought process to tuning queries. Thanks for this.

Awsome!

Why do you keep saying you don't like us?

Great video...as usual learn lots from your demo(s). Something worth noting for future videos? Even though I tried following along, using SQL Server 2019, no matter what I did, the estimated and actual number of rows were always the same (yes I switched compatibility levels)...any ideas what the problem was? Okay if you didn't glance at the answer already, startup server parameters (i.e. -T2453 and/or -T4199...forget which one (possibly both))!! Took me a while to figure that one out!!

This is awesome, you don't even know how grateful I'm with you. Thanks Brent!

Thanks for your help to the SQL community!

Great work Brent!

That was awesome!

Would it make a difference replacing
"WHERE (u.DownVotes + u.UpVotes + u.Reputation + u.Views) > 1000000"
with
"WHERE MagicInterestingTotal > 1000000"
?

hi @Brent I'm using StackOverflow2010 (10GB version) and it does not have function dbo.fnGetPostType

Awesome! How much do your charge?