In SQL Server, updates and inserts are processed initially into a B-tree table called a delta store. Eventually, a process called a tuple mover compresses the data into the columnstore structure.

SQL Server 2012 includes a lot of new and exciting features. One feature that has caught the imagination of many in the user community is the high-performance feature called Columnstore Indexes.

Low-cardinality columns—columns with less than 200 distinct values do not have the selectivity required in order to benefit from standard b-tree index structures. No support for SQL functions ...

I'm trying to figure out the best (maintainable, efficient, etc.) way to store and retrieve an ordered tree in a SQL database.I've got an application (C# WinForms) that has a TreeView which ...