Database %d was shutdown due to error 9002 in routine ‘HeapPageRef::Update’.
So I hit the error in the title the other night while converting a heap to a clustered index on a production system. After this error poped up, some other nasty stuff showed up in the error log, which I’ve included below. Error: 9002, Severity: 17, State: 4. The transaction log for database ‘%d’ is […]
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 […]