Transaction log growth best practices
There is a lot of talk online about transaction log growth and what you should do. There are two answers to this question, and in this post I’ll give you both answers. The theoretical answer is that you want to grow your transaction logs in 8 gig chunks. This will maximize the amount of space […]
How HyperBac worked for me
I recently installed HyperBac on a clients SQL Server to reduce the amount of space needed to store their backups. Specifically we were looking to reduce the amount of space the log backups took, but I was curious to see how much space the full backups would be reduced by. The full backups were ~53 […]
What does WITH (NOLOCK) actually mean
Contrary to popular belief WITH (NOLOCK) isn’t actually the SQL Server “Turbo” button. While it may appear that way, there’s actually some stuff going on in the back that makes it look this way. Understanding what is happening is critical to using WITH (NOLOCK) correctly. When you use the NOLOCK query hint you are telling […]
SQL Server Consolidation at #SQLExcursions
The fifth and final session that I’ll be presenting at SQL Excursions is on SQL Server Consolidation. There are lots of ways to consolidate SQL Server databases, and some times the wrong method of consolidation is selected by people. Knowing all of the options when working on a SQL Server Consolidation project is key to […]