SQL Server

  1. Home
  2. SQL Server
  3. (Page 12)

Inline Table Valued Functions: Parameter Snorting

You’ve probably heard about parameter sniffing But there’s an even more insidious menace out there: Parameter Snorting. It goes beyond ordinary parameter sniffing, where SQL at least tried to come up with a good plan for something once upon a compile. In these cases, it just plain gives up and throws a garbage number at…
Read More

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

This week, Brent, Erik, and Richie discuss AlwaysOn Availability Groups, execution plans, speeding up log shipping, applying wrong service packs, why servers “page wildly” when copying mid to large-size files from one SQL server to another, their favorite high availability solutions, and much more! Here’s the video on YouTube: You can register to attend next week’s Office…
Read More

SQL Server DBA’s Guide to the Gitlab Outage

This week, developer tools company GitLab had a serious database outage. The short story: An admin was trying to set up replication The site had an unusual load spike, causing replication to get behind While struggling with troubleshooting, the admin made a lot of changes After hours of work, the admin accidentally deleted the production…
Read More
Pocket Square

First Responder Kit Updates: So Many Updates, Brent Quit

I got 128 GB of RAM just to develop sp_BlitzCache with! Also, thanks to @RichBenner @BrentOzar and @douglane for code, and @LitKnd and @HenrikStaunPoulsen for great ideas! Grab the newly updated First Responder Kit, and here’s what’s in it: sp_Blitz Improvements #677 Finally! A bug that isn’t ours! Microsoft forget to let SE clean up…
Read More

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

This week, Brent, Erik, Tara, and Richie discuss sp_Blitz capabilities, what’s best to use for resolving SQL performance issues, CDC, tools for capturing wait stats, their favorite monitoring tools, temp tables vs table variables, partitioning with constraints, and whether you should get any certifications. Here’s the video on YouTube: You can register to attend next week’s Office…
Read More

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

This week, Brent, Erik, Tara, and Richie discuss restoring databases from Enterprise Edition to Standard Edition servers, their favorite way of collecting SQL server metrics, extended events, career advice, how to tell what processes SQL uses memory for, and much more! Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe…
Read More

[Video] Office Hours 2017/1/4 (With Transcriptions)

On this first Office Hours call of 2017, Brent, Erik, Tara, and Richie discuss multi-server jobs, how to find motivated Junior DBAs, working with SAP databases, partitioning, AlwaysOn Availability Groups, tracking SQL users, SQL monitoring tools, data capture, source archiving, and much more! Here’s the video on YouTube: You can register to attend next week’s Office Hours,…
Read More
Pocket Square

Your 10 Favorite Blog Posts of 2016

Here’s the stuff you clicked on this year: 1. When Shrinking TempDB Just Won’t Shrink – Tara Kizer – If there’s two things you people love, it’s TempDB and shrinking databases. Pair the two of them together, and it’s like peanut butter and jelly. 2. Cheat Sheet: How to Configure TempDB for SQL Server –…
Read More

Some Plans Are Wider Than Others

Using the publicly available Stack Overflow database (the 100GB 2016/03 version), here’s an execution plan for an update statement: The Narrow Plan (click to see PasteThePlan details) It’s a pretty simple query – it just scans the Posts table looking for any post with PostTypeId = 8, and then updates a single field for the first 250…
Read More
Menu
{"cart_token":"","hash":"","cart_data":""}