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...
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...
When your SQL Server database is left to “auto-grow” without a maximum limit, you will run out of hard drive space. Believe me, I learned the hard way! In this blog post, I will talk about the two ways you can keep your transaction log file small; either backup your...
Recent Comments