Product has been added to your cart.

SQL Server

Decrypting Insert Query Plans

Erik Darling
Execution Plans, SQL Server
6 Comments
We’ve all been there Staring at a simple query that has a three mile long execution plan. After the first time, you learn to always look to make sure there’s not a secret view involved. After looking at query plans for modifications involving indexed views, I decided to look at some other fairly common table…
Read More

CTEs, Views, and NOLOCK

Erik Darling
Humor, SQL Server
12 Comments
This is a post because it surprised me It might also save you some time, if you’re the kind of person who uses NOLOCK everywhere. If you are, you’re welcome. If you’re not, thank you. Funny how that works! I was looking at some code recently, and saw a CTE. No big deal. The syntax…
Read More

[Video] Office Hours 2017/03/22 (With Transcriptions)

Brent Ozar Unlimited Team
SQL Server, Videos
8 Comments
This week, Tara, Erik, and Richie discuss statistics updates, in-place upgrades, row vs page compression, deadlocks, replacing SQL backup vendors, server load, ETL, and whether they think that database mail should be used by user applications to send their emails. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to…
Read More

This Is Your Backup Schedule On Drugs

Erik Darling
SQL Server
21 Comments
I’ve seen things Terrible things. I mean, not just working here (which, as I write this, I’m three days away from the two year mark, fingers crossed!), but also out there on the internet. Once you leave the safe confines of Brent Ozar Unlimited, you’re subject to the ravages of space. Strangers. Radiation. Strangiation. Your…
Read More

[Video] Office Hours 2017/03/08 (With Transcriptions)

Brent Ozar Unlimited Team
SQL Server, Videos
4 Comments
This week, Erik and Richie discuss creating/updating statistics, tools for viewing large flat file tables, the worst code they have ever seen, high disk queue length, dealing with databases that store blobs, reindexing jobs, transparent data encryption, and more. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our…
Read More

[Video] Office Hours 2017/03/01 (With Transcriptions)

Brent Ozar Unlimited Team
SQL Server, Videos
6 Comments
This week, Brent and Tara discuss Always On failure scenarios, partitioning without consulting vendors, multi-subnet clustering with AGs, licensing, long running queries, replication, improving index maintenance, avoiding deadlocks, index space usage, and much more. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the…
Read More

New White Paper: How to Build an Always On Availability Group in Google Compute Engine

Brent Ozar
Always On Availability Groups, Google Compute Engine, SQL Server
21 Comments
You’re a database administrator, Windows admin, or developer. You want to build a Microsoft SQL Server environment that’s highly available, and you’ve chosen to use Always On Availability Groups. Our newest white paper – download In this white paper we built with Google, we’ll show you: How to build your first Availability Group in Google…
Read More

[Video] Office Hours 2017/02/22 (With Transcriptions)

Brent Ozar Unlimited Team
SQL Server, Videos
2 Comments
This week, Erik, Tara, and Richie discuss tempdb etiquette for developers, elastic search vs full-text search, server CPU spiking issues, source control in a database project, querying transaction logs, and more. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Enjoy the…
Read More

Max Worker Threads: Don’t Touch That

Erik Darling
SQL Server
57 Comments
More isn’t faster I’ve had people give me all sorts of janky reasons for changing Max Worker Threads. I’ve even had people tell me that someone from Microsoft told them to do it. The thing is, all changing that setting does is help you not run out of worker threads. It doesn’t make queries run…
Read More
Pocket Square

[Video] Office Hours 2017/02/08 (With Transcriptions)

Brent Ozar Unlimited Team
SQL Server, Videos
3 Comments
This week, Brent, Erik, Tara, and Richie discuss compatibility levels, SQL server SPN problems, Always On Availability Groups, failover clustering, capturing DML stuff, disc defragmentation, replication snapshots and reindexing, load testing, PowerShell, and whether you should pursue the path of a DBA. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or…
Read More