Monthly Archives: August 2008

How To Upgrade To SQL Server 2008

Now that SQL Server 2008 has released to manufacturing (RTM), you need to start planning how you will upgrade from a previous version of SQL Server to SQL Server 2008.  This will depend on which version of SQL Server you … Continue reading

Posted in SQL Server 2008 | 5 Comments

Cumulative Update Package 10 For SQL Server 2005 SP2

Microsoft has announced CU10 for SQL Server 2005 SP2. The CU is not yet available, but Microsoft has been pretty reliable about releasing Cumulative Updates every eight weeks.  I am wondering when they will actually release SP3 for SQL Server … Continue reading

Posted in SQL Server 2005 | 4 Comments

New Product Name and Logo From Intel

Intel announced the official name for their upcoming Nehalem family of processors. It will be called the Intel Core i7.  Here is a little blurb about it: Nehalem is Intel’s dynamically scalable and innovative new processor microarchitecture — Nehalem will … Continue reading

Posted in Computer Hardware | Leave a comment

How To Use sp_configure In SQL Server 2008

In order to check and set the value of many configuration options in SQL Server 2008 (and 2000\2005), you can use the sp_configure system stored procedure. In order to see and set many of the options, you need to call … Continue reading

Posted in SQL Server 2008 | 1 Comment

Suggested Max Memory Settings for SQL Server 2005/2008

It is pretty important to make sure you set the Max server memory setting for SQL Server 2005/2008 to something besides the default setting (which allows SQL Server to use as much memory as it wants, subject to signals from … Continue reading

Posted in SQL Server 2008 | 5 Comments