Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Storage Engine » SQL Server 2008   (RSS)
Wednesday, June 17, 2009 9:14 AM

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
Posted by wesback | 2 Comments
Friday, February 13, 2009 10:52 AM

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
Posted by wesback | 1 Comments
Thursday, October 09, 2008 10:00 AM

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