It’s Optober – a time to look at all the SQL Server sp_configure options and figure out what they do and why they are there. In this post we look at ‘show advanced options’, just incase anyone can’t figure out what it does from the name.
Read More →Author: Rob
Optober: A Month of SQL Options:
It’s Day One of Optober, a month dedicated to forcing me to blog more regularly by going through the options in sp_configure one by one and blogging about what they are for, when you should use them, and when you shouldn’t.
Read More →Stupid SQL Things To Do: Backup to NUL
Occasionally I’ve come across a site where backups are taken to disk = ‘NUL’. Note that’s NUL with 1 L and not NULL with 2 L’s. I’ve seen it recommended in a few places online as a quick fix where a log file has grown out of control and at least one SQL backup utility actively uses it under the guide of ‘truncating the transaction log’.
Read More →NSSUG – Session 1: Paul Randal on Wait Stats
Thanks to all those who made it to our first user group meeting tonight. Paul Randal gave a great session on the Waits and Queues Troubleshooting methodology and we had some really good discussion.
Read More →Nelson SQL Server User Group
Wanted to take a moment to announce the great news that Nelson now has it’s own SQL Server User Group. You can join in at the Nelson SSUG page. Even better news is we have Paul Randal lined up as our first presenter. The session is at 6pm on the 17th September at the #GIGATOWNNSN […]
Read More →Database Corruption Causes C-drive to Fill Up
Ever been fighting corruption on a server you don’t usually have anything to do with and suddenly get a message that C-drive is running out of space? This happened to me today and not knowing the server I wasn’t sure if a very low amount of disk space on C-drive was normal or was something I was causing.
Read More →Why are Primary Databases Smaller Than Log Shipped Secondaries?
This week I was asked a simple question by a client – why are the files for the primary databases smaller than the corresponding files on the log shipped secondary? Obviously it needed to have something to do with either Growth or Shrink operations, so I set up a test to find the answer.
Read More →