SQL Server with Mr. Denny:

Microsoft Windows


March 2, 2008  11:45 AM

New Article: Configuring SQL Server memory settings



Posted by: Denny Cherry
Article, RAM, SQL

I've recently published a new tip on SearchSQLServer.com called "   Bookmark and Share     2 Comments     RSS Feed     Email a friend

March 2, 2008  4:43 AM

New Article: Create an upgrade plan for your move to SQL Server 2005



Posted by: Denny Cherry
Article, Config, Installation, SQL, SQL Server 2005, SQL Server 2008

I’ve published a new tip over on SearchSQLServer.com entitled “Create an upgrade plan for your move to SQL Server...

Bookmark and Share     0 Comments     RSS Feed     Email a friend


February 13, 2008  10:37 AM

New Article: Configuring SQL Server memory settings



Posted by: Denny Cherry
Article, Cache, RAM, SQL

I’ve published a new tip over on SearchSQLServer.com entitled “   Bookmark and Share     0 Comments     RSS Feed     Email a friend


February 11, 2008  8:00 AM

Getting those memory setting in SQL Server just right.



Posted by: Denny Cherry
Config, Microsoft Windows, RAM, SQL, Windows Computing

When using 64bit SQL Server getting the memory settings right is pretty easy.  Simply set the maximum to what you want and you are good to go. Getting them right in the 32bit versions of SQL Server is a bit harder.  You have to deal with the OS level of enabling the Physical Address Extensions...


January 28, 2008  8:00 AM

Guide to Installing SQL 2000 and SQL 2005 on the same machine



Posted by: Denny Cherry
Installation, SQL, SQL Server 2000, SQL Server 2005

You can install SQL 2000 and SQL 2005 on the same machine.  I always recommend that they be installed in this order to try and get everything working as best as possible.

  1. Install SQL 2000
  2. Install SQL 2005
  3. Install SQL 2000 SP4 (Or the latest service...


January 24, 2008  8:00 AM

Best way to get assistance on the messages boards.



Posted by: Denny Cherry
Assistance, Support, Tech support

There are literally thousands of different message boards on the Internet where you can find technical information from fellow IT professionals.  When asking questions on these boards there are some basic guidelines which most people like to have followed.  They are sometimes informal, but they...


January 17, 2008  12:00 PM

MS KB Article with all the hot fixes listed



Posted by: Denny Cherry
Article, Bug, SQL, SQL Server 2005, Support

I found this great little MS KB article today.  It's got all the SQL Server 2005 post SP2 host fixes including bug numbers and descriptions of the bug.  The MS KB article ID is 937137. Denny


December 5, 2007  8:00 AM

A well timed code freeze is critical to keeping your sanity.



Posted by: Denny Cherry
Family, Support

Doing a code freeze at this time of year can be crucial to keeping your sanity this time of year.  Often times the business unit likes to push out last minute changes before the year end.  This often means pushing last minute code (which as everyone knows isn't always perfect) which can lead...


December 3, 2007  8:00 AM

SQL 2008 November CTP



Posted by: Denny Cherry
Beta, CLR, Installation, SQL Server 2008

We'll I've finely gotten around to installing the SQL 2008 November CTP.  While walking through the installer I have seen some excellent changes.  Not only is the option to change the paths of the data files no longer hidden, there are more than just two options.  There are at least 7 paths that...


October 18, 2007  6:18 PM

Excellent Lock Pages in Memory Blog



Posted by: Denny Cherry
Microsoft Windows, SQL

Bob Ward of Microsoft has written an excellent blog about the lock pages is memory right over on the PSS blog.


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: