12 Ways To Rewrite SQL Queries for Better Performance
HTML-код
- Опубликовано: 4 авг 2024
- 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.
Subscribe and turn on notifications to never miss a weekly video: ruclips.net/user/DataWithBer...
Read the full post with examples:
bertwagner.com/2019/05/28/12-...
Follow me on Twitter:
/ bertwagner - Наука
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
I wish you showed some example, kinda hard to understand for a beginner. But great video! Very informative
He covered some of those examples in his previous videos. Check them out :)
He linked the full article with examples in the bio: bertwagner.com/posts/12-ways-to-rewrite-sql-queries-for-better-performance/
Tutorial starts at 1:51
i dont mean to be so off topic but does anyone know a tool to get back into an Instagram account..?
I was stupid forgot my account password. I would love any tricks you can give me.
Bert, Congratulations on hitting 2000 subscribers. Always great useful information. Keep it coming, we really enjoy it.
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! :)
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.
#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!!
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 RUclips. 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!
The video is informative but much help for a beginner. He definitely need to elaborate those pointes more. If we wanted to read his blog why would we watching youtube video instead.
I appreciate his effort but he could have been a but more verbose and better.
You're new I'm just starting this video... I'm gonna watch this..
Well resumed!
instant sub :: Thank you for making this
Very very very usefull. Thank you!
What’s the diff between copy data and materialized views?
Good work, brother!
really a great video
Thank you hey but had to go online for examples,can you please include those in your next videos 😊😊
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
good work
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!🤓
Hi Leeyo , did you find any solution
, I had that trouble following me to the view.
Usually when I revisit a query I wrote months ago I can do better
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.
No examples?
Please execute some examples in ur video
looks like frankie muniz
Why not add examples? Why should I watch on you?
Just talk ..and talk..and talk...
this makes no sense swapped off video comparing IN to UNION ALL .. literterally not even comparable at all
Music - Too distracting for me = dislike
and here I am having cmd.ExecuteNonQuery(); ERROR 😂
#BEGINNER