Category Archives: Query Tidbits

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”. … Continue reading

Share
Posted in Query Tidbits, SQLServerPedia Syndication | Leave a comment

The Primary Filegroup Cannot be Backed Up as a File Backup

File Group backups are great when working with very large databases (VLDB’s) that have been partitioned.  Typically when I come across File Group backups implemented in production the database is using the full recovery model. With the full recovery model … Continue reading

Share
Posted in Backups/Recovery, Query Tidbits, SQLServerPedia Syndication | Leave a comment

How to check for last SQL Server backup

As a database professional, I get asked to review the health of database environments very often. When I perform these reviews, one of the many checks I perform is reviewing backup history and making sure that the backup plans in … Continue reading

Share
Posted in Backups/Recovery, Query Tidbits, SQLServerPedia Syndication | 20 Comments

SQL Server Installation Date

I have been working on a project recently to collect system metrics of a SQL Server environment. One of the items that came up that would like to collected is the date that SQL Server was installed on the server.  In … Continue reading

Share
Posted in Query Tidbits, SQLServerPedia Syndication, Tibits | 1 Comment

What is Page Life Expectancy (PLE) in SQL Server

Being a production DBA means having to quickly look at a SQL Server and diagnose issue with it. We know that a quick look at perfmon or task manager can tell us of high CPU usage, but what is a … Continue reading

Share
Posted in Query Tidbits, SQL Tuning, SQLServerPedia Syndication | Tagged , | 3 Comments

SQL Server – Cannot resolve collation conflict

A friend of mine contacted me through email today having a very common problem with a query he had written.  He received an error, “cannot resolve collation conflict for equal to operator”. Early in my career I had experienced the … Continue reading

Share
Posted in Query Tidbits, SQLServerPedia Syndication | Leave a comment

How to restore the tail end of a transaction log

Have you ever tried to restore a backup over an existing database and receive an error stating the tail of the log for the database has not been backed up? Many times if you are just restoring a database into … Continue reading

Share
Posted in Backups/Recovery, Presentations, Query Tidbits, SQLServerPedia Syndication | Tagged , , , , | 5 Comments

Find the version of the Master DB from a backup

Try researching recovering the master database online and you will see countless references to having to have SQL at the same version and builld level as the backup of the master database.  Since most folks probably don’t have a routine … Continue reading

Share
Posted in Backups/Recovery, Query Tidbits | Leave a comment

Collect Database File Size with Powershell

I decided to start monitoring the amount of free space in my database files so that I can make sure all my databases are set to auto grow by the right amount and to monitor the amount of free space … Continue reading

Share
Posted in PowerShell, Query Tidbits, SQLServerPedia Syndication | Leave a comment

Change Database Owner

This is post is going to be very simple but it is something I come across ever so often and find myself having to look up the syntax most of the time.  I guess it is one of those things … Continue reading

Share
Posted in Query Tidbits, SQLServerPedia Syndication | Leave a comment