What about when incomplete statements are sitting in your server, not moving, just hogging resources? Use this script for Extended Events...

Retrieve data about size and space used for all the files in the current database with this script. Some tips on database file size...

It’s T-SQL Tuesday time, and this month’s host, Boris Hristov (blog|twitter) chose the topic of interviews. Over the time as a SQL Server...

This Thursday, 10AM GMT, I will be hosted by Dell’s Richard Douglas (blog|twitter) for a webcast. I will present my session called “Small...

Ever needed to install and configure an SQL Server instance environment, including the operating system? If you asked me to estimate the...

Earlier this week, I delivered a presentation called “Query Progress Tracking in SQL Server” to my local user group. Among other...

This script displays the last date and time of each backup type for each database. It’s useful when you need to know quickly when a...

Let’s say you are developing an SSIS package on your dev box to load data from an Excel file to SQL Server. For this example, let’s...

I don’t like the MERGE statement. The syntax is weird, it’s tricky in terms of locks, and it has a history of weird errors. The other day...

Here’s a newsflash: You may not thing so, but you are expensive. There’s no point in endless performance tuning. I love performance...