Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2005   (RSS)

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

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

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
Posted by wesback | 0 Comments

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 .
Posted by wesback | 0 Comments
Filed under:

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

Cumulative update package 8 for SQL Server 2005 Service Pack 2

As already announced here , the CU8 package for SQL Server 2005 SP2 has been released. Do not forget about the self service hotfixes - more information here .
 
Page view tracker