SQL Server v.Next ("Denali") : How a columnstore index is not like a normal index

Posted by AaronBertrand on SQL Blog See other posts from SQL Blog or by AaronBertrand
Published on Mon, 28 Feb 2011 17:34:00 GMT Indexed on 2011/02/28 23:31 UTC
Read the original article Hit count: 409

Filed under:

Apollo

|

column store

|

Columnstore index

|

CTP1

|

Denali

|

SQL 11

|

SQL Server 11

|

SQL Server 2011

At the end of my Denali presentation at SQL Saturday #65 in Vancouver, a member of the audience asked, "What makes a columnstore index different from a regular nonclustered index?" At the end of a busy day, I was at a loss for an answer, and I'll explain why. First, I'll briefly explain the basic, core, high-level functionality of a columnstore index (you can read a lot more details in this white paper ). Basically, instead of storing index data together on a page, it divvies up the data from each...(read more)

© SQL Blog or respective owner

Related posts about Apollo

Apollo linux boot into single user

as seen on Server Fault - Search for 'Server Fault'
We have a device that runs Appolo Linux and I have to boot that device into a single user mode so that i can run a fsck to check the hard drive for errors. I've been goggling this during the past hour and so far I haven't found any specific method on how can I do that on this version on Linux. The… >>> More
SQL Server v.Next ("Denali") : How a columnstore index is not like a normal index

as seen on SQL Blog - Search for 'SQL Blog'
At the end of my Denali presentation at SQL Saturday #65 in Vancouver, a member of the audience asked, "What makes a columnstore index different from a regular nonclustered index?" At the end of a busy day, I was at a loss for an answer, and I'll explain why. First, I'll briefly explain the basic… >>> More
Growing Plants that have been Exposed to Lunar Soil [Video]

as seen on How to geek - Search for 'How to geek'
Lunar soil was brought back to Earth during the days of NASA’s Apollo program and scientists eagerly started conducting experiments with it. This short video discusses some of the research and results when plants from Earth were exposed to soil from the Moon. You can read more about these experiments… >>> More
Volume group disappeared, LVs still available

as seen on Server Fault - Search for 'Server Fault'
I've run into an issue with my KVM host which runs VMs on a LVM volume. As of last night the logical volumes are no longer seen as such (I can't create snapshots of them even though I have been for months now). Running any scans all result in nothing being found: [root@apollo ~]# pvscan No matching… >>> More
Any good C++ Component/Entity frameworks?

as seen on Game Development - Search for 'Game Development'
(Skip to the bold if you want to get straight to my question :) ) I've been dabbling in the different technologies available out there to use. I tried Unity and component based design, managing to get a little guy up and running around a map with basic pathfinding. I really loved how easy it was… >>> More

Related posts about column store

Metro: Introduction to CSS 3 Grid Layout

as seen on Stephen Walter - Search for 'Stephen Walter'
The purpose of this blog post is to provide you with a quick introduction to the new W3C CSS 3 Grid Layout standard. You can use CSS Grid Layout in Metro style applications written with JavaScript to lay out the content of an HTML page. CSS Grid Layout provides you with all of the benefits of using… >>> More
Metro: Introduction to CSS 3 Grid Layout

as seen on Stephen Walter - Search for 'Stephen Walter'
The purpose of this blog post is to provide you with a quick introduction to the new W3C CSS 3 Grid Layout standard. You can use CSS Grid Layout in Metro style applications written with JavaScript to lay out the content of an HTML page. CSS Grid Layout provides you with all of the benefits of using… >>> More
php foreach question

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following code $oldID=-1; $column=0; foreach($pv->rawData as $data){ if ($oldID!= $data->relativeTypeID){ $oldID= $data->relativeTypeID; $column++; $row=1; } echo "Row: ".$row.": Column: ".$column.": ID".$data->relativeTypeID."<br>";… >>> More
Update table.column with another table.column with common joined column

as seen on Stack Overflow - Search for 'Stack Overflow'
Hit a speed bump, trying to update some column values in my table from another table. This is what is supposed to happen when everything works Correct all the city, state entries in tblWADonations by creating an update statement that moves the zip city from the joined city/state zip field… >>> More
Test Column exists, Add Column, and Update Column

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to write a SQL Server database update script. I want to test for the existence of a column in a table, then if it doesn't exist add the column with a default value, and finally update that column based on the current value of a different column in the same table. I want this script to be… >>> More