Search Results for “first responder kit”

Live Blogging: Erik vs. PowerShell

Last Updated July 29, 2017

Oh, hey, happy Saturday First, I’d like to apologize to Conor Cunningham for the blatant theft of a blog title. That’s what you get for not posting in three years (like the desert miss the rain~). Why am I here? Why am I writing PowerShell, my sworn enemy? I do it for you. I’m trying…

ColumnStore Indexes And Recursive CTEs

Last Updated July 26, 2017

Erik Darling

Columnstore Indexes, Indexing, SQL Server

Alone Together When I think about SQL Server features, I often picture a high school cafeteria. AGs are making fun of Mirroring, index rebuilds are walking around taking everyone’s lunch, dta is making a glue sandwich, and no one knows who Service Broker is even though they’ve been going to school together since Kindergarten. At…

[Video] Office Hours 2017/07/19 (With Transcriptions)

Last Updated July 23, 2017

Brent Ozar Unlimited Team

SQL Server, Videos

This week, Erik and Richie discuss performance tuning, relativity, Always On Availability Groups, parameter sniffing, technical debt, unit testing, deadlocks, testing storage performance, 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 Podcast? Don’t miss an episode, subscribe…

sp_BlitzCache: Eventual Compatibility With Azure

Last Updated November 16, 2017

Erik Darling

Execution Plans, Microsoft Azure, sp_BlitzCache

Better than nothing Yesterday it was announced that global temp tables were available in public preview for Azure. That means that unmodified versions of sp_BlitzCache (which uses a global temp table to hold a whole bunch of information) will be compatible up there. This is a nice addition for Azure, and an even nicer addition…

Query Plans: Trivial Optimization vs Simple Parameterization

Last Updated June 16, 2017

Erik Darling

Execution Plans, Indexing, SQL Server

Facemaking You know when you think you know something, and the obviousness of it makes you all the more confident that you know it? That’s usually the first sign that there’s a giant gotcha waiting for you. And that’s what happened to me over the weekend. The setup I answered a question. And after I…

Automated Tuning And The Future Of Performance Tuners

Last Updated June 7, 2017

Erik Darling

Consulting, SQL Server

Before you get too excited This isn’t a dive into any of the new automated tuning features of SQL Server 2017. I’m interested in them because Microsoft thinks they can put us out of business with them, but… Fat chance. See, a lot of the automated performance tuning features assume you EVER HAD GOOD PERFORMANCE…

Don’t Use Scalar Functions in Views.

Last Updated May 1, 2021

Erik Darling

T-SQL

The short story: if your view has a scalar user-defined function it it, any query that calls the view will go single-threaded, even if the query doesn’t reference the scalar function. Now for the long story. Quite often people will inherit and rely on views written back in the dark ages, before people were aware…

What Do You Want to See in a Free Query Store Tool?

Last Updated May 19, 2017

Erik Darling

Execution Plans, Monitoring, Query Store (QDS), SQL Server

I love Query Plans No seriously, I love digging into query plans. Even writing XQuery to dig into them in sp_BlitzCache. I was both honored and horrified to take over development of it from Jeremiah. It’s a beast, but it’s my kind of beast. At around 4500 lines of code, when you want to make…

SQL Server 2017: Statistics Information Comes To Query Plans

Last Updated May 15, 2017

Erik Darling

Execution Plans, SQL Server 2017, Statistics

Warm fuzzies I think this is how my mom would have felt if I went to college. You see, once you stop cargo culting around index fragmentation, and disk queue length, you start to realize which things are actually important to query performance. Things like statistics, and cardinality estimation. And, sure, having the right indexes…

Status Update On Query Plan Hash Bug

Last Updated April 21, 2017

Erik Darling

Execution Plans

Not long ago I posted about a bug

Look Ma, Adaptive Joins

Last Updated May 12, 2017

Erik Darling

Execution Plans, SQL Server 2017

This probably won’t seem like a big deal soon But I just got the optimizer to pick an Adaptive Join! It took a few tries to figure out what would cause some guesswork to happen, but here it is. I hope Joe Sack has strong ribs. And here’s the tool tip info! Dynamic Duo This…

How to Join the SQL Server Community Chat in Slack

Last Updated December 11, 2020

Brent Ozar

GroupBy Conference

Just another day on Slack Slack is a team chat system where you can: Go to SQLslack.com to get a free instant invite, and then join Go to https://SQLcommunity.Slack.com, or download the Slack app Meet cool people and join their chat rooms Chat rooms at SQLCommunity include: #SQLhelp and #PowerShellHelp – very active #FirstResponderKit – questions and…

Decrypting Insert Query Plans

Last Updated March 25, 2017

Erik Darling

Execution Plans, SQL Server

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…

From The Mailbag: DBCC CHECKDB And Read Only Databases

Last Updated March 23, 2017

Erik Darling

CHECKDB and Corruption, SQL Server

We got an email!!! It was weird. It was from an Australian, and it was right side up. I could hardly believe it. Normally we encourage people to ask us questions during Office Hours, or over on Stack Exchange. That way lots of people can benefit from the answer. But since this reader is on…

Connect Item: Query Plan Hash in sys.dm_exec_query_stats vs Query Plan Hash in the query plan

Last Updated March 18, 2017

Erik Darling

SQL Server

Shifty Henry said to Bugs You know those moments when you’re looking at something for so long, and it’s still not working, and you’re pretty sure you’re losing that final grip on your sanity? Well, that feeling was multiplied this week by an odd bug that I found, where Query Plan Hashes in system views…

sp_BlitzCache Tip: Cutting Through Heavy Dynamic SQL Use

Last Updated November 16, 2017

Erik Darling

First Responder Kit, sp_BlitzCache, T-SQL

It keeps me up at night Out of the box, sp_BlitzCache will give you enough stuff to work on in your server’s plan cache to last a month of leap days. This is great for most people, but if you use a ton of dynamic SQL in stored procedures, it can make things difficult. What’s…

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

Last Updated February 25, 2017

Brent Ozar Unlimited Team

SQL Server, Videos

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…

Crappy Missing Index Requests

Last Updated November 16, 2017

Erik Darling

Execution Plans, Indexing, sp_BlitzIndex

When you’re tuning queries It’s sort of a relief when the first time you get your hands on it, you get the plan and there’s a missing index request. Even if it’s not a super high-value one, something in there is crying for help. Where there’s smoke, there’s a bingo parlor. But does adding missing…

Simulating Workload With ostress And Agent Jobs

Last Updated February 14, 2017

Erik Darling

Load Testing, SQL Server

This question comes up a lot Especially during Office Hours, and the answer is usually… not great. You can spend a lot of money on people and complicated software to design, run, and monitor workloads against test environments, or you can throw together tests with some free tools like SQL Query Stress or Microsoft’s RML…

Analyzing Temporary Stored Procedures with sp_BlitzCache

Last Updated November 16, 2017

Erik Darling

First Responder Kit, sp_BlitzCache, TempDB

All the cool kids Know that when you’re trying to figure out why a stored procedure is slow sometimes, you should use a temporary stored procedure instead of pulling the code out and running it ad hoc. We frequently point people to Erland Sommarskog’s “Slow in the Application, Fast in SSMS“, because it’s an excellent…

Search Results for “first responder kit”

Hi! I’m Brent Ozar.