Lock Pages In Memory in SQL Server Standard Edition

Until now “Lock Pages In Memory” was an option only available to SQL Server Enterprise Edition customers.  Very simply put it prevents SQL Server from paging out the memory it has allocated (a deep explanation can be found in the references below).  We got a lot of feedback from customers who wanted to have support for this in…


Cumulative update package 2 for SQL Server 2005 Service Pack 3

Time to take SQL Server 2005 SP3 to build 9.00.4211 with this new CU2 for SP3.More information here. For those of you who are still on SP2 there is a cumulative update package which takes you to build 9.00.3315.More information here.


Cumulative update package 1 for SQL Server 2005 Service Pack 3

We know this is a bit unusual but we have released the first cumulative update package for SQL Server 2005 SP3 too, this time it will take you to build 9.00.4207.  This CU contains the fixes that are in CU10 & CU11 for Service Pack 2. More information can be found here. Happy holidays!


SQL Server 2005 Service Pack 3

The service pack many people have been waiting for has been released.  Now I need to remember another build number (9.00.4035) 😉Get it here. For those of you who are still on SP2, we also released CU11 for SQL Server 2005 SP2 which will take you to build 9.00.3301.  More info here. Of course all…


SQL Server 2005 SP3 – Beta

The first public beta of Service Pack 3 for SQL Server 2005 is now available for download.  This is obviously for testing purposes only!  If you have feedback please feel free to let us know on Connect.


What happens when I update my partitioning key?

This is a question someone asked me yesterday and if you think about it, this is really a good question. The partitioning function defines on which partition the row will be mapped based on the partitioning column value.  Imagine that you have a table on which you have defined partitioning to make all rows with…