Your online resource for SQL Server query tuning
It’s time to continue the series on internals of storage structures. I already covered the more standard storage types in the parts about on-disk rowstore, columnstore indexes, memory-optimized storage, and memory-optimized columnstores, and in the last episode of this series I started to cover specialized storage structures by looking at XML indexes. Microsoft introduced limited... The post…
(Warning: This blog post is non-technical but purely personal. In my leukemia diary, I write openly about my current health issues. This blog might be triggering for people who struggle with, or lost dear ones to, cancer and other similar diseases.) It’s now almost three weeks since my last update. I finished the seven days... The post Slow progress is better than no progress appeared first on…
EDIT 1: I have confirmed receipt of all mails about owned blocks and levels. If you did not receive a confirmation, then please use the contact form to reach out to me. EDIT 2: It took some time, but eventually Vimeo Customer Support managed to get my account restored, get the videos online again, and... The post Vimeo messed up, and you and I get the consequences appeared first on SQLServerFast .
When Adam Machanic started T-SQL Tuesday, I bet that nobody, least of all himself, expected it to run for over ten years. Yet, here we are. Not ten, but over 16 years later. Or 200 months, to be exact. This anniversary edition is hosted by Brent Ozar. And his chose topic is: query red flags.... The post T-SQL Tuesday 200 – Query red flags appeared first on SQLServerFast .
Welcome back to my plansplaining blog series, where I dive deep into the details of non-obvious execution plans. This part is also a sort of follow up on my post from two weeks ago, when I wrote about the structure and usage of XML indexes, and had to admit that I had not been able... The post Plansplaining part 34 – XML indexes revisited appeared first on SQLServerFast .
(Warning: This blog post is non-technical but purely personal. In my leukemia diary, I write openly about my current health issues. This blog might be triggering for people who struggle with, or lost dear ones to, cancer and other similar diseases.) Last week, my near future was clear. I would go through the official entry... The post Change is the only constant appeared first on SQLServerFast .
(Warning: This blog post is non-technical but purely personal. In my leukemia diary, I write openly about my current health issues. This blog might be triggering for people who struggle with, or lost dear ones to, cancer and other similar diseases.) It’s exactly a month after my last leukemia diary entry. Not much happened for... The post Another crazy week appeared first on SQLServerFast .
After covering on-disk rowstore, columnstore indexes, memory-optimized storage, and memory-optimized columnstores, it is now time to turn our attention to storage structures that are used for specific datatypes only. The first “victim” will be the XML index. When you need to store XML data in a SQL Server database, you can choose between two data... The post Storage structures 5 – XML indexes…
During the past months, in between working on new videos, I have also made various updates to existing videos in the SQLServerFast Execution Plan Video Training. Since I pushed two really big updates (over half an hour of added content!) live today, I decided that now is a good time to let everyone know what... The post Video training update 2026 appeared first on SQLServerFast .
It’s time to finish the triptych on bad parameter sniffing, and how Microsoft tries (and fails) to fix this for you. After first talking about bad parameter sniffing in general, I used my last video to explain Parameter Sensitive Plan Optimization, the feature that Microsoft released in SQL Server 2022 as an attempt to fix... The post Optional Parameter Plan Optimization appeared first on…