Great video! Thanks for sharing all this information. I would have liked to see how this works on a production database too. For example, suppose I need to run a query every month on a large table that everyone uses. In my case, I want an index on that table for my specific query. However, I don't want to disrupt the workflow of my fellow SQL developers. I think this could be an interesting aspect to cover as well.
Great question! We talk about that in detail in both my Fundamentals of Index Tuning class and my Fundamentals of Query Tuning class. The short answer is no, though.
Seek beats Scan.... Scan beats Battlestar Galactica 😜 Covering index is good but not if the engine just keeps saying ever single additional query needs its own nci too 🤦♂️
Yep, we build on that in our Fundamentals of Index Tuning class, where we explain how to create as few indexes as possible for as many queries as possible. See you there!
Great video! Thanks for sharing all this information.
I would have liked to see how this works on a production database too. For example, suppose I need to run a query every month on a large table that everyone uses. In my case, I want an index on that table for my specific query. However, I don't want to disrupt the workflow of my fellow SQL developers. I think this could be an interesting aspect to cover as well.
This is making me look back in pain at all of my shitty query tuning attempts at my last job
I know, right? That's my entire career...
I mostly love videos with timestamps, but all the same great video
Glad you like them!
If i may ask, to know all this what did you do? Any books ? courses? offical docs?
Lots of information on query tuning. The king of SQL Server is Itzik ben gan. He wrote several books on this topic
I like how you didn't invert colors on your second piece of paper
I really, really like your content, but do you hear your soundboard while it is playing? At the volume it is playing at in the video? 😁
TURN DOWN FOR WHAT
do all function invalidate index usage?
Great question! We talk about that in detail in both my Fundamentals of Index Tuning class and my Fundamentals of Query Tuning class. The short answer is no, though.
💯👏👏👏
Everytime Brent steps out of frame it looks like he's been snapped by Thanos 🤣
HA!
👏👏🙏
Seek beats Scan.... Scan beats Battlestar Galactica 😜
Covering index is good but not if the engine just keeps saying ever single additional query needs its own nci too 🤦♂️
Yep, we build on that in our Fundamentals of Index Tuning class, where we explain how to create as few indexes as possible for as many queries as possible. See you there!
"How to Think Like the SQL Server Engine" ... that's easy, just invoice everyone thousands of dollars every time you say something. :)