12 Ways To Rewrite SQL Queries for Better Performance

In this episode we explore a variety of ideas for rewriting queries to improve performance when you can't do things like change server settings or modify indexes.

Read the full post with examples:

Follow me on Twitter:

[notsonathan]

I wish you showed some example, kinda hard to understand for a beginner. But great video! Very informative

[tharun]

4:19 Forcing Join Orders
4:38 Inline UDFs
5:02 Creating UDFs for Serialization
5:34 NOT IN vs NOT EXISTS
5:54 Data Compression
6:24 Materialized Views
6:48 Cordiality Estimator Hinting
7:30 Copy the data elsewhere

[gracehan]

Really precise to the point yet short video, summarizing all the important topics. For those guys who gave the thumbs down (so UNFARE), you should get SQL 101 series from some other youtubes (tons of them available), before your comments. This video is the best length and quality for such condensed topic. Worth viewing 20 times and more. Also the examples are nicely laid out in the blog (for those who read), in depth. For any developers or even casual SQL users, please read besides watch Youtube. If examples are included in this video, then it would be a video for 2 hours, then many other people will complain (about its excessive length), then comments would have been: please take those boring examples out from the video. This video is a summary for experienced SQL users. I have found it the best so far, among the 200 other videos that came out from my search engine. 5 star video!

[ashleyli]

Thank you so much for sharing! Would be nice to see some examples though. I am a data analyst myself and it's hard to find easy-to-understand and useful content like this online. Please keep up with the great work and looking forward to see more quality contents! :)

[sql]

Bert, Congratulations on hitting 2000 subscribers. Always great useful information. Keep it coming, we really enjoy it.

[MrJrhzues]

You're new I'm just starting this video... I'm gonna watch this..

[KristinaMyLife]

Thank you! It is so smooth and useful. From my experience SQL Server 2016 and newer is just using a derived table in the plan no matter what is in a query text.

[Zanoni]

#8 was probably RBAR vs Set statements - Rookie performance mistake :-)

Congrats on 2000+ people whom you have helped!!! You don't always know how far the ripples in a pond go when you drop the stone in!! Keep on dropping knowledge on us, sir!!

[data]

this is pretty high level. The info in here is like expert/advanced. Will have to revisit this vid and your blog post later on when I am ready to start utilizing these strategies. Thanks so much.

[siyanasithole]

Thank you hey but had to go online for examples, can you please include those in your next videos 😊😊

[American]

congratulations on your 2000, keep it up, you deserve more definitely. When it comes to employment in database field, what would be salary that someone would ask for with your amount of knowledge. I know that I don't know as much as you do but just for a guideline

[shreysom]

instant sub :: Thank you for making this

[danew]

Usually when I revisit a query I wrote months ago I can do better

[pioleonardo]

Hi, how can you identify slow-running queries? is there a tool to pinpoint slow-running queries? like, I have a long query with CTE, JOINS, and subqueries. How can the plan or a tool identify which query runs slow? Thank you!🤓

[sf]

Why not add examples? Why should I watch on you?

[Mrstealurgrill]

What’s the diff between copy data and materialized views?

[Indian-norr]

Please execute some examples in ur video

[Helloimtheshiieet]

this makes no sense swapped off video comparing IN to UNION ALL .. literterally not even comparable at all

[johnmorsley]

Music - Too distracting for me = dislike

[JessaC]

and here I am having cmd.ExecuteNonQuery(); ERROR 😂
#BEGINNER