Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2005 » SQL Server 2008   (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

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
 
Page view tracker