Does SQL Server Database Compatibility Level Matter?

Not long ago, I was dealing with a performance problem involving a very simple SQL Server query. To give you an idea about what I mean, this query took over six hours to complete! This didn’t make any sense to me especially when its “twin” query took only 25-seconds...

How to Define the Size of a SQL Server Database

In a couple of recent blog posts I talked about two ways to prevent the SQL Server database from running out of disk space because of transaction logs, and what I did when I discovered that my SQL Server Reporting Services (SSRS) database was using a ridiculous amount...