The Curious Case of… almost online index rebuilds

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.)

I had a comment on my blog a few weeks ago from someone who hadn’t known that online index operations acquire blocking table locks – yes they do!

When I’m teaching the index fragmentation module of our IEPTO1 class, I like to joke that the marketing team back