Microsoft Windows

Getting those memory setting in SQL Server just right.

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

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

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

Best way to get assistance on the messages boards.

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

MS KB Article with all the hot fixes listed

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

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

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

SQL 2008 November CTP

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