SQL Server Columnstore Index Performance Demonstration

Leave a comment (0) Go to comments
SQL Server Columnstore Index Performance Demonstration youtube Video
This video presents a demonstration of the level of query performance that can be achieved for data warehouses and data marts in SQL Server Denali with the new columnstore index and enhanced query execution capability. Performance in this demonstration when using a columnstore index improves on the order of a stunning 50 times for a single query. This is for the same data on the same hardware, compared to the previous release of SQL Server when running the query over a fact table stored in a PAGE-compressed clustered B-tree index ordered by date. The bottom line is that users will get more business value out of their data and make better decisions with columnstore indexes in SQL Server because they can explore data much more interactively.
From:
sqlserver
Views:
222
SQL Server Columnstore Index Performance Demonstration youtube Video  SQL Server Columnstore Index Performance Demonstration youtube Video  SQL Server Columnstore Index Performance Demonstration youtube Video  SQL Server Columnstore Index Performance Demonstration youtube Video  SQL Server Columnstore Index Performance Demonstration youtube Video
1
ratings
Time:
04:18
More in
Science & Technology
EOF - SQL Server Columnstore Index Performance Demonstration, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.