Tag Archives | SSMS

Who Has The DAC?: Or How I Found Out I Had The Dedicated Admin Connection On SQL Server

Here’s a quick little snippet of T-SQL script that will hopefully prove handy to someone (and that I’ll end up googling at some point and find my own blog post). Are you trying to determine who is currently using the dedicated admin connection (aka DAC) on a particular SQL Server? Did SSMS give you a […]

Error when trying to use DAC connection in SQL Server

So, one of my local databases got stuck in single-user mode. Easy solution? Connect to my instance using SQL Server’s Dedicated Admin Connection (aka DAC) and flip the database back to multi-user. Easy! Wait. What? TITLE: Connect to Database Engine —————————— Cannot connect to ADMIN:localhost\SQL2012. —————————— ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while […]

SQL Query: List All Indexes And Their Columns

Looking to write a SQL query which will list out all the indexes in your database as well as the columns in the index? Well my friend you’ve come to the right place. The query below will give list out the following information: Schema Table Name (or view) Index Name Is Primary Key Is Unique […]

Parse and sort SET STATISTICS IO output with Excel

I wish I could say this was my idea. Somebody posted it on twitter awhile back and I did the classic “facepalm”. I have no idea how many times I manually picked apart the results of SQL Server’s SET STATISTICS IO ON without considering creating a formula to handle it for me. So, somebody came […]

SQL Server Management Studio: Recover Lost Files

Nooooooooo!  Power outage+unsaved files SQL Server Management Studio files=Panic!!!  Wait a sec.  Don’t panic.  Every modern application, especially Microsoft apps, prompts you after a crash and asks you if you want to recover your lost files right?  Right!?!  Somehow, SSMS does NOT include this feature.  Why?  No idea.  Blame Management Studio’s stability.  It rarely shutsdown […]

Use F5 To Execute A Query In Visual Studio

If you’re coming to Visual Studio 2010 from SQL Server Management Studio you’re probably getting annoyed by the fact that pressing the F5 does not execute your SQL when using the T-SQL Editor window. Do not fear! Like the $6 Million Dollar Man, “we have the technology… Better… Stronger… Faster.” Instead of the three buttons […]