Categories
Uncategorized

Column­-Stores For Wide and Sparse Data

Over the weekend I read a paper titled Column­-Stores For Wide and Sparse Data by Daniel J. Abadi.  Below is a quick summary of the points made by Abadi followed by some thoughts / application for SQL Server’s ColumnStore index. Wide Tables & Column “Elimination” I’ve already discussed (in a previous post) why ColumnStores are […]

Categories
Uncategorized

Sequence vs Identity – Performance Comparison

Recently, as part of an effort to support a few database design choices, I spent a bit of time researching the performance characteristics of the new sequence objects available with SQL Server 2012. The main objective was to gain an understanding of how they stacked up performance-wise with the IDENTITY property…which is the predominant design pattern […]