A full transaction log can occur for a number of reasons. Typically it is due to the log not being truncated with regular transaction log backups, or something else not allowing the log to truncate. I often find Change Data Capture enabled and the jobs not running, SQL Server Replication in place and replication not […]
Category: Query Tidbits
SQL Best Practices
SQL Server has evolved a great deal since I first started working with SQL Server 6.5 in 1998. Unfortunately I continually come across newer systems that are configured with old ‘best practices’. Things like 1 tempdb file per core, 1 core per socket on VMware machines, index rebuilds each night, and more. Below are some […]
Purging SQL Server Backup History
It seems like every few weeks I come across a database server with a very large msdb. After a small amount of investigation work, I determine that the largest tables consuming the most space are all related to backup history. I typically only keep 30 days of backup history but I’ve seen as little as […]
There Is Insufficient Free Space on Disk Volume To Create the Database
I have been involved in countless database migrations. Most of the time I have access to the existing source servers and future destination servers. In cases where you have access to both environments, it is very easy to evaluate and clean up any issues with the source databases. In situations where you are only provided […]
Dynamic Data Masking – SQL Server
Use Dynamic Data Masking to protect your data
SSRS Management for the DBA
Things a DBA should know about SSRS
How to Reset the SA Password When Locked Out
Getting locked out of a SQL Server instance can happen due to a number of situations. The most common scenario I’ve encountered is when a SQL Server is moved from one domain to another without the domain being trusted or having a local SQL admin account. I recently encountered another incident where a DBA was […]
An error occurred while executing batch. Error message is: Arithmetic Overflow
Recently an incident came across my desk where an end user was receiving an error trying to retrieve some records from the database. The error message the customer received was “An error occurred while executing batch. Error message is: Arithmetic Overflow”. Experience has taught me that this message is related to an invalid dataset within a […]