Monday, November 07, 2011

SQL Server 2012 ColumnStore, a video...

Journey to SQLAuthority - SQL SERVER – Video – Performance Improvement in Columnstore Index

"I earlier wrote an article about SQL SERVER – Fundamentals of Columnstore Index and it got very well accepted in community. However, one of the suggestion I keep on receiving for that article is that many of the reader wanted to see columnstore index in the action but they were not able to do that. Some of the readers did not install SQL Server 2012 or some did not have good machine to recreate the big table involved in the demo.

For the same reason, I have created small video for that.


I have written two more article on columstore index. Please read them as followup to the video:

SQL SERVER – How to Ignore Columnstore Index Usage in Query

SQL SERVER – Updating Data in A Columnstore Index" [GD: Post leach level: 99%]

Sometimes a 4 minute video is all you need...


Related Past Post XRef:
A couple SQL Server ColumnStore references...

SQL Server 2012 Edition and Licensing Revamp Round-up

Playing with SQL Server 2012 the easy way, via a Microsoft and Amazon partnership for SQL Server 2012 on AWS/EC2 (Think "5 Minutes to Denali")
Want Denali CTP3 (aka next version of SQL Server)? Here's a Hyper-V VHD just for you (in 36 parts, but I've also provided direct download URL's for use in your DM of choice...)

"Introducing Microsoft SQL Server Code Name 'Denali'" Free (draft two chapter preview) eBook
SQL Server Denali Sequence Object Overview
SQL Server Denali Feature Watch - FORMAT(), as in, "OMG we finally get .Net like Number/Date/Time formatting in our TSQL" Or "Saying goodbye to my old friend, Convert(103)..."
Time to start thinking about, and providing feedback on, what you’ll need to upgrade to Denali (aka next version of SQL Server)
Denali CTP3 introduces LocalDB - Think SQL Server Express crossed with SQL CE (or SQL CE grown up or SQL Express made as almost as easy CE)
SQL Server Denali FileTables Feature - The fruits of WinFS? (Think "A FileStream enabled table that you can access as a network file share and other standard File IO API's" or "SQL Server File System in a Table")

No comments: