SQL Server with Mr. Denny:

Error Message


May 15, 2013  2:00 PM

Error Handeling and DBCC CHECKDB

Posted by: Denny Cherry
Database Administration, Error Message, ERRORLOG, SQL Server, SQL Server stored procedures, Stored Procedures

A client that I've been working at for a while needed to start doing DBCC CHECKDBs on their production server.  We hadn't been for a little...

April 12, 2012  2:00 PM

CPU Affinity Mask and virtualizating SQL Servers

Posted by: Denny Cherry
Error Message, Grant Fritchey, Hyper-V, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2

If you have physical SQL Servers that you plan on moving into a virtual environment you'll want to double check your affinity mask settings before actually moving the machine from a physical server to a VM when using P2V software.  The reason for this is that if the affinity mask is set for...

January 15, 2009  11:00 AM

Reading the Error Messages is key

Posted by: Denny Cherry
Error Message, Tech support

I have a gripe that I need to air. I can't stress this enough.  Actually reading the error messages when there is a problem is key to solving the problems. Most of the time (I admit, not all the time) SQL Server will give you some very useful information about what to do next.


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: