This is the third post in the “Parameterization” series. In the previous post I mentioned parameter sniffing. This is a very important...

A short while ago, I was asked to create a certain report with a “Windows File Share” subscription. The client wanted the file to be...

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