Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Column-based query accelerator in SQL Server 2012

I have been researching, SQL Server 2012 (aka Denali) and Microsoft has a pre-release available. The pre-release is located here with some information on key features. As I have downloaded the pre-release and installed on a VM. I have been curious about the following key feature mentioned. But Im not sure of its ability.

Column-based query accelerator

Column-Based Query Accelerator will help dramatically increase query
performance ~10x and reduce
performance tuning through interactive
experiences with data for near instant
response times and streamlined setup
which removes the need to build
summary aggregates.

What I would like is to see some explanation of the performance enhancement and perhaps an example, as I do not understand What "Column-based query" acceleration is? Any Insight would be helpful.

like image 261
John Hartsock Avatar asked Nov 21 '10 15:11

John Hartsock


1 Answers

Sounds like a Business Intelligence thing.

Query aren't "interactive" and don't generally have "summary aggregates".

MS has put a lot into Analysis Services.

Edit: it's also possible that it's already known and blogged about, but the marketing monkeys changed the name :-)

like image 51
gbn Avatar answered Sep 18 '22 18:09

gbn