The new ColumnStore feature coming in SQL Server Denali looks very interesting and possibly officially awesome, but it's also something that's going to take long time SQL Server'ers a but to wrap our heads around. To get started on that, here's a couple related references. It's not much, but every journey begins with a first step...
SQLTune - What is a columnstore index?
"Upcoming SQL Product, introduces a new data warehouse query acceleration feature based on a new type of index called columnstore. Before we move any further exploring this new feature, I want to take time to explain the basics behind a columnstore index and how different is it from a traditional index (rowstore).
What is columnstore? And what is a rowstore?
To understand this, lets see a simple illustration below. Here I have a table with 4 columns (First name, Email, Phone, Street Address) . Below is a representation of how the index data will be stored and their associated pros and cons.
..."
TechNet Wiki - TechNet Articles - SQL Server Columnstore Index FAQ
The SQL Server columnstore index feature speeds up data warehouse query processing, in many cases by a factor of 10 to 100. We'll be posting answers to frequently asked questions here.
Overview
What is Project Apollo?Apollo is the code name for new functionality that will be available in SQL Server code-named “Denali,” that will substantially accelerate common data warehouse queries. Apollo introduces two new features: a columnstore index and a new query execution mode that processes data in batches.
What is a column store?
...
What is a columnstore index?
...
What do I have to do to use Apollo?
...
Is Apollo in CTP 1? When can I try it?
No, Apollo is not available in CTP 1. Apollo will be available in CTP 3 and in the final released product."
No comments:
Post a Comment
NOTE: Anonymous Commenting has been turned off for a while... The comment spammers are just killing me...
ALL comments are moderated. I will review every comment before it will appear on the blog.
Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...
I reserve, and will use, the right to not approve ANY comment for ANY reason. I will not usually, but if it's off topic, spam (or even close to spam-like), inflammatory, mean, etc, etc, well... then...
Please see my comment policy for more information if you are interested.
Thanks,
Greg
PS. I am proactively moderating comments. Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...