SQL Server

kCura Relativity, SQL Server

This sounds really cheesy, but I’m honestly excited to be presenting again this year at kCura Relativity Fest 2015. Here’s what I’ll be talking about: How to Check Your SQL Server’s Health The Abstract: You’re a system or database administrator responsible for the uptime and performance of Relativity’s SQL Servers, but you’ve never received professional…

Out of Office: Time For the Brent Ozar Unlimited Retreat

Last Updated August 11, 2015

Thank you for your web visit. We’re out of the office and will be back on Monday, August 3. During this period we will have limited access to our email. We’ll still have full access to Twitter, Facebook, and Instagram. We apologize in advance about that, because we’re going to be posting a lot of…

Finding Tables with Nonclustered Primary Keys and no Clustered Index

Last Updated February 13, 2017

Indexing, SQL Server

i’ve seen this happen Especially if you’ve just inherited a database, or started using a vendor application. This can also be the result of inexperienced developers having free reign over index design. Unless you’re running regular health checks on your indexes with something like our sp_BlitzIndex® tool, you might not catch immediately that you have…

New Cardinality Estimator, New Missing Index Requests

Last Updated August 15, 2024

Amazon Web Services (AWS), SQL Server

Indexing, SQL Server

During some testing with SQL Server 2014’s new cardinality estimator, I noticed something fun: the new CE can give you different index recommendations than the old one. I’m using the public Stack Overflow database export, and I’m running this Jon Skeet comparison query from Data.StackExchange.com. (Note that it has something a little tricky at the…

The Easiest Way to Restore Transaction Logs to A Point In Time (Spoiler: Use AmazonRDS)

Last Updated February 13, 2017

Kendra Little

… is to use a SQL Server where a robot does it for you! Let’s take a look at how you can do this in AmazonRDS’s hosted SQL Server these days. Normally, restoring transaction logs is super tedious. You’ve got to restore all the files in the right order, for every single database. Even if…

Database Connection Hazards with Entity Framework

Last Updated July 15, 2015

Doug Lane

I recently came across a curious case where a SQL Server was suffering a number of long-running queries coming from an application written in Entity Framework. When I measured the average query execution times, I got some unexpected results: CPU time: 12 milliseconds Reads: 273 Elapsed time: 6800 milliseconds Wait, what? Looking at the wait stats…

Logical Query Processing

Last Updated March 12, 2018

Execution Plans, SQL Server

You can’t do that on management studio Recently, while working with a client, I did something in a query that they were mystified by. I didn’t think much of it, but I thought it might be useful to you, dear readers, as well. Along with an explanation. Here’s a sample query that takes advantage of…

13 Questions to Ask Before You Touch a Database Server

Last Updated July 2, 2015

I’ve touched a lot of SQL Servers over the years. After my share of trips to HR for inappropriate touching, here’s the questions I ask first these days: Is this in production now? If this goes down, what apps go down with it? When those apps go down, is there potential for loss of life…

Creating a branch in the GitHub client for Windows

Pull Request 101 for DBAs Using GitHub

Last Updated July 10, 2015

Kendra Little

I’ve worked with source control quite a bit over the years — everything from ye olde Visual Source Safe to Subversion to TFS. I even supported the Source Depot system at Microsoft as an engineer for a year back in the day! These days I don’t use source control a ton. We keep repositories of…

The sp_rename follies

Last Updated June 29, 2015

Before we get started… I know. I know. BOL. It’s documented. They even show you how to rename a table. Thanks, sp_rename! But sometimes… You just forget. And as with most simple mistakes, fixing them is… Weird. Here’s what happened to me recently, when I was working on a table swapping demo. Transact-SQL CREATE TABLE…

Three Easy Tweaks to Tune Up Your SQL Server

Last Updated July 2, 2015

Doug Lane

I’ve been doing SQL Critical Care® work with clients for over a year now. It’s absolutely true that every client’s situation is different and needs special attention. However, I’ve found that there’s a short list of issues that nearly all clients have in common. Drawing from that list, here are the top three high-impact, low-effort areas you can work…

An Update to SQL Server Management Studio is Available

Last Updated July 3, 2015

Cloud Computing, SQL Server

That’s the message you get in your tray if you open SSMS 2016 today: SSMS Update Available Then click Tools, Check for Updates, and you get: Check for Updates What’s awesome is that I didn’t even install SQL Server Management Studio from the new standalone installer – this is my full CTP2.1 installation of SQL Server,…

The Fastest Way to Reconfigure a Bunch of Servers

Last Updated June 20, 2015

Jeremiah Peschka

… is to use a SQL Server where a robot does it for you! I stole that from Kendra – someone else already wrote the sentence for me and why not keep re-using things, right? Configuring SQL Servers the Usual Way What’s the usual way to do this? There are a few commercial tools on…

Indexing for GROUP BY

Last Updated March 12, 2018

Indexing, SQL Server

It’s not glamorous And on your list of things that aren’t going fast enough, it’s probably pretty low. But you can get some pretty dramatic gains from indexes that cover columns you’re performing aggregations on. We’ll take a quick walk down demo lane in a moment, using the Stack Overflow database. Query outta nowhere! Transact-SQL…

Should You Put Things in the master Database?

Last Updated May 16, 2019

Always On Availability Groups, Backup and Recovery, SQL Server

Growing up as a young boy, my elementary teachers always warned me about the perils of putting stuff in master. But what’s the real deal? Why is this such a bad idea? System databases are often located on space-limited drives. The default installation parameters for SQL Server throw master, model, and msdb all on the…

New SQL Server Management Studio 2015/June – with Check for Updates!

Last Updated June 24, 2015

This morning, Microsoft announced a new standalone SQL Server Management Studio download: This is our first effort to release SQL Server Management Studio (SSMS) in a mechanism outside of the SQL Engine releases. Our goal is to update this frequently with new features, fixes and support for the newest SQL Server features in SQL Server…

New Updates for sp_Blitz®, sp_BlitzCache™

Last Updated June 19, 2015

We’ve just updated our First Responder Kit to include new versions of these tools: sp_Blitz® v41 – June 18, 2015: Added check 162 for CMEMTHREAD waits on servers with >= 8 logical processors per NUMA node. Added check 159 for NUMA nodes reporting dangerously low memory in sys.dm_os_nodes. Added check 161 for a high number of cached…

Indexing for Windowing Functions

Last Updated August 15, 2024

Indexing, SQL Server, T-SQL

Hooray Windowing Functions They do stuff that used to be hard to do, or took weird self-joins or correlated sub-queries with triangular joins to accomplish. That’s when there’s a standalone inequality predicate, usually for getting a running total. With Windowing Functions, a lot of the code complexity and inefficiency is taken out of the picture,…

Announcing the Dell DBA Days: August 25-28

Last Updated August 18, 2015