ColumnStores vs. RowStores: I/O Performance and Compression

One of the major benefits associated with ColumnStore  indexes is increased I/O performance.  Below are two of the more common explanations for this bump in I/O performance… ColumnStores only retrieve data (from storage) necessary to satisfy the query This notion is inherent in the column-oriented architecture…data pages in column-oriented storage only contain data from a single …

Continue reading

Robert Frost and Pie Charts

Earlier this year, Microsoft released an incredible self-service reporting and presentation tool called Power View (with SQL Server 2012).  It’s highly interactive, has excellent visualizations, and I could go on and on about the value it adds to businesses currently leveraging the Microsoft BI stack.  Instead, I’d like to point out the huge statement Microsoft  made …

Continue reading