SQL Server with Mr. Denny:

Microsoft CSS


October 30, 2013  2:00 PM

TempDB latch timeouts with lots of RAM

Posted by: Denny Cherry
Blocking, Database Administration, Microsoft CSS, RAM, SQL Server, SQL Server 2008 R2, TempDB

Recently I had an interesting problem where the SQL Server 2008 R2 instance would randomly in the middle of...

December 22, 2011  2:00 PM

Fragmentation may cause corruption

Posted by: Denny Cherry
Microsoft CSS, SQL Server

Let me start this off by saying that I chose the title of this blog post very carefully.  You'll note that it says "fragmentation may cause corruption" not that it will cause corruption, so before you go saying "Denny says that if you have any fragmentation of the database it'll become...

May 6, 2010  11:00 AM

If you change the default instances port number, you may not be able to connect

Posted by: Denny Cherry
Microsoft CSS, SQL Server

Something that some companies like to do is to change the port number that the default instance is listening under as a security precaution.  However this has a habit of stopping anyone from connecting to the default instance without knowing the port number. This is because the default instance...

April 26, 2009  5:29 AM

SQL Server Standard Edition getting Lock Pages in Memory

Posted by: Denny Cherry
Bob Ward, Bug, Lock Pages, Microsoft CSS, SQL Server 2005, SQL Server 2008

Microsoft SQL Server 2005 and 2008 Standard edition will be getting the Lock Pages in Memory feature that SQL Server Enterprise Edition has had starting in SQL Server 2005.  This was announced by Bob Ward via the

March 30, 2009  7:45 PM

SQL 2008 Clusters require treaking to make SQL Dumpter work

Posted by: Denny Cherry
Microsoft CSS, SQL Dumper, SQL Server 2008

If you don't already read the CSS teams blog, I suggest that you do.  A little while ago they posted a blog post about how the

January 7, 2009  11:27 PM

Installing SQL Server 2005 SP3 or SQL Server 2008 on XP Prep SP3 can cause Bug Check

Posted by: Denny Cherry
Bug Check, Microsoft CSS, SQL Server 2005, SQL Server 2008

The SQL Server CSS team has just posted a


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: