Welcome back to the series on internals of storage structures. I first covered the standard storage types in the episodes on on-disk rowstore, columnstore indexes, memory-optimized storage, and memory...

Two and a half months ago, I informed you that Vimeo decided to shut down their VOD service, forcing me to find a new platform for hosting my videos and handling the sales. For me, that meant a lot of...

Introduction The Iterator icon is not actually an operator. It is just an icon, intended to be used to represent operators for which no dedicated icon is available. I have so far only seen this icon b...

Introduction The Cursor icon is not actually an operator. It is just an icon, similar to Language Element, but used specifically for cursor statement that do not need their own dedicated execution pla...

Welcome back to the plansplaining series. Probably the one with the longest, and least clickbaity title. The idea of plansplaining is to take a single execution plan and then fully dissect it, until e...

(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 ...

This site has different types of readers. Those that come here to quickly look up something, using it as the reference this is. And those that read everything, or at least the pages they consider inte...

Introduction The Fast Forward “operator” is not actually an operator. It is the equivalent of the Language Element “operator” for the container of a fast forward cursor. The Fast Forward operator is n...

This site has different types of readers. Those that come here to quickly look up something, using it as the reference this is. And those that read everything, or at least the pages they consider inte...

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 storag...

(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 ...

I am furious right now. Vimeo has made a mistake, and as a result, the SQLServerFast Execution Plan Video Training is currently not available for viewing. Vimeo’s announcement Four days ago, I got a n...

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 site has different types of readers. Those that come here to quickly look up something, using it as the reference this is. And those that read everything, or at least the pages they consider inte...

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...

(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 ...

Introduction The Snapshot “operator” is not actually an operator. It is the equivalent of the Language Element “operator” for the container of a static cursor. The Snapshot operator is not used in an ...

(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 ...

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...

This site has different types of readers. Those that come here to quickly look up something, using it as the reference this is. And those that read everything, or at least the pages they consider inte...

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 ...

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 t...

Introduction The Fetch Query “operator” is not actually an operator. It is the equivalent of the Language Element “operator” for one of the two queries contained in a cursor definition. The Fetch Quer...

Time for the next part in my series on storage structures. The previous parts covered on-disk rowstore, columnstore indexes, and memory-optimized storage. In this part, I will look at the combination ...

Bad hair day? Try having an almost-no-hair month! Jokes aside. It has been almost six weeks since my last video blog. Not really the schedule I had planned. But I believe I have good reasons. Anyway, ...

(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 ...

Introduction The Population Query “operator” is not actually an operator. It is the equivalent of the Language Element “operator” for one of the two queries contained in a cursor definition. The Popul...

(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 ...

I create a lot of videos for the SQL Server community. These come in three categories. Recordings of conference sessions. Sometimes made by myself, sometimes by the conference organization. Typically ...

Time for a new video blog. This time, the topic is bad parameter sniffing. And with 43 minutes, the video is a bit longer than what I normally shoot for. What is it? What can you do about it? The vide...

(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.) In my previous post, I wrote about the ups and downs as I was...

(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 ...

(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 ...

For a change, a video about security, rather than performance and execution plans. Why? Well, that should become clear in my next planned videos. Although I really can’t predict when I’ll be able to r...

(Warning: This blog post is non-technical but purely personal. I write openly about my current health issues. This blog might be triggering for people who struggle with, or lost dear ones to, cancer a...

(Warning: This blog post is non-technical but purely personal. I write openly about my current health issues. This blog might be triggering for people who struggle with, or lost dear ones to, cancer a...

SQL Server 2025 introduced Optimized Locking. Not one, but two features, sharing a single marketing name. Lock After Qualification (LAQ) One of these two features is Lock After Qualification (LAQ). Th...

My training videos in the SQLServerFast Execution Plan Video Training are never just a done deal. Whenever there is new information to share, either because Microsoft adds new functionality, or becaus...

If you read this blog, then it is very likely that you have an interest in execution plans. And that you want to increase your understanding of execution plans. A great way to really get to the next l...

After discussing traditional on-disk rowstore storage in part 1 and columnstores in part 2, it is now time to turn our eye towards memory-optimized storage structures in SQL Server. Memory-optimized s...

SQL Server 2025 introduced Optimized Locking. Not one, but two features, sharing a single marketing name. Transaction ID (TID) Locking One of these two features is Transaction ID (TID) Locking. Slated...

It’s the second Tuesday of the month again. Time for T-SQL Tuesday, edition 195. This edition is hosted by Pat Wright, who wants to know whether our code aged well. The timing of that question could n...