Many times, when I perform query tuning, the problem that causes the query to perform badly is related, one way or another, to...

Introduction Many times I happen to find myself in a situation where, as a DBA, I need to write some long and cumbersome code (usually...

On Saturday, I had the pleasure to present my session, “Things You Can Find in the Plan Cache”, at SQLBits! Thanks to everyone who...

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...