Posts by Brent Ozar

[Video] Office Hours: Húsavík Harbor Edition

Today’s session comes to you from the harbor in Húsavík, the whale watching capitol of Europe. Questions I answered in the video: 00:00 Introductions 00:29 Is SQL Server 2019 ready for prime time now? 02:47 Does WITH NOLOCK cause high CPU usage? 04:53 Is MERGE a good practice or bad? 06:36 OPENROWSET is so easy…
Read More
Office Hours - ask me anything.

Upcoming Office Hours: Get Your Questions In Now

Company News
From time to time, when my incredibly busy (cough)vacation(/cough) schedule permits, I do a live Office Hours stream where I take your questions and answer ’em live. I’m going to do a couple of them this week, but I’m going to do them disconnected. I’ll be recording them on the road – Erika and I…
Read More

Tweets You Missed

You don’t follow me on Twitter because you’re not on Twitter, and I can’t say that I blame you. It’s a bunch of people yelling at each other. Come to think of it, I’m not even sure why *I’m* on there. But anyway, here are a few things I’ve said on there lately that you’ll…
Read More

Why Are Linked Server Queries So Bad?

No, I don’t want to be your valentine. Remember when you were in school, and you had a crush on someone? You would write a note asking them to be your valentine, and you’d ask a mutual friend to pass the note over to them. The adult equivalent is linked server queries. When your query…
Read More
Fundamentals of Columnstore

Lock Escalation Sucks on Columnstore Indexes.

Columnstore Indexes
1 Comment
If you’ve got a regular rowstore table and you need to modify thousands of rows, you can use the fast ordered delete technique to delete rows in batches without hitting the lock escalation threshold. That’s great for rowstore indexes, but…columnstore indexes are different. To demo this technique, I’m going to use the setup from my…
Read More