Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2005 » SQL Server 2008   (RSS)

Scale up with SQL Server 2005 / SQL Server 2008 - NUMA

This article is related to the NUMA (Non Uniform Memory Access) feature available with SQL Server. NUMA is a very useful feature to scale up the Server. Even before we discuss how SQL Server 2005 supports NUMA we have a few questions that needs to be

Data Compression with SQL Server 2005 SP2 and SQL Server 2008

One of the very useful feature introduced in SQL Server 2005 SP2 and SQL Server 2008 is vardecimal data type. When the databases are growing every day it is a significant concern for the DBAs to use the storage space efficiently. Bigger the row size then
 
Page view tracker