Home > IT Blogs > SQL Server with Mr. Denny/

SQL Server with Mr. Denny:

Error Message

1
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 while due to maintenance window constraints on their old production server.  Now that we've scaled the application across 6 different servers we can now do...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

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...

  Bookmark and Share     1 Comment     RSS Feed     Email a friend

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.

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1