Data Compression and Heaps

I think we can all agree that Data Compression is a great new functionality in SQL Server 2008.  I know many of you have been experimenting with it but there was one little catch I wanted you to be aware of.When you apply page compression to a table the pages get compressed when they are…

2

The Data Loading Performance Guide

SQL Server has been gaining a lot of credibility in the data warehousing market the last couple of years.  With that the challenge arises more and more to load massive amounts of data in SQL Server.  Obviously this is a matter of good hardware in combination with the ‘right’ way of doing things.  Lucky for us there is…

1

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…

0