I just finished watching the hosted customer even in San Francisco where the Microsoft CEO Satya Nadella, COO Kevin Turner, CVP of Data Platform Group Quentin Clark and the SQL Server Product Marketing GM Eron Kelly officially introduced the new release of the SQL Server 2014. In this post I am not going to give … Continue reading Few thoughts on the SQL Server 2014 launch event in San Francisco
Tag: Columnstore Index
SAP HANA versus Microsoft Business Intelligence and xVelocity
This will be in a long rant format as I am still trying to organize my thoughts around this subject. Before I start comparing and contrasting the two vendors, I just wanted to make a quick statement to get something off my chest: Generally speaking, HANA is a good business decision for SAP as it … Continue reading SAP HANA versus Microsoft Business Intelligence and xVelocity
xVelocity and Columnstore Indexes review
Today I decided to take xVelocity and columnstore indexes for a spin and see whether this technology lives up to all the hype. I tested it on a 2Gb fact table with about 21M rows. First I wrote a query that joined the fact table with a Customer dimension and returned the total revenue grouped … Continue reading xVelocity and Columnstore Indexes review
Column Store indexes – performance tuning and best practices
great article about Column store indexes and best practices around them