Enhancements to SQL Server Column Stores

Summary: Column store indexes are updatable and usable as base table storage, enabling data warehouses to exploit columnar layout. Batch processing gains broadened with new operators and a strengthened optimizer in the upcoming release to address initial limitations. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 4641
Venue: SIGMOD
Year: 2013
Pagerank: 0.00013207641
Overall Rank: 1,223 | 91.50%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 26 of 26 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
241	DB2 with BLU Acceleration: So Much More than Just a Column Store	2013	VLDB	0.00031420034
418	Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age	2014	SIGMOD	0.00023729211
853	Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask	2018	VLDB	0.00015940507
1,098	Trill: A High-Performance Incremental Query Processor for Diverse Analytics	2015	VLDB	0.00014114442
1,611	Qd-tree: Learning Data Layouts for Big Data Analytics	2020	SIGMOD	0.00011147324
1,807	H2O: A Hands-free Adaptive Store	2014	SIGMOD	0.00010487796
2,312	Real-Time Analytical Processing with SQL Server	2015	VLDB	9.0530853e-05
2,772	Quickstep: A Data Platform Based on the Scaling-Up Approach	2018	VLDB	8.1401661e-05
3,219	Interleaving with Coroutines: A Practical Approach for Robust Index Joins	2018	VLDB	7.3550716e-05
3,488	Optimal Column Layout for Hybrid Workloads	2019	VLDB	7.0479329e-05
3,644	BtrBlocks: Efficient Columnar Compression for Data Lakes	2023	SIGMOD	6.8854928e-05
3,779	Instance-Optimized Data Layouts for Cloud Analytics Workloads	2021	SIGMOD	6.7747205e-05
3,973	Apache Hive: From MapReduce to Enterprise-grade Big Data Warehousing	2019	SIGMOD	6.5758017e-05
4,282	Scaling Up Concurrent Main-Memory Column-Store Scans: Towards Adaptive NUMA-aware Data and Task Placement	2015	VLDB	6.293052e-05
5,109	Adaptive NUMA-aware data placement and task scheduling for analytical workloads in main-memory column-stores	2017	VLDB	5.6908086e-05
5,113	Columnstore and B+ tree – Are Hybrid Physical Designs Important?	2018	SIGMOD	5.687445e-05
5,633	Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server	2023	VLDB	5.4011156e-05
5,670	Joins on Encoded and Partitioned Data	2014	VLDB	5.3804618e-05
5,905	Exploiting Ordered Dictionaries to Efficiently Construct Histograms with Q-Error Guarantees in SAP HANA	2014	SIGMOD	5.2788785e-05
6,345	Operator and Query Progress Estimation in Microsoft SQL Server Live Query Statistics	2016	SIGMOD	5.1023048e-05
6,466	Pando: Enhanced Data Skipping with Logical Data Partitioning	2023	VLDB	5.0528281e-05
6,803	Proteus: Autonomous Adaptive Storage for Mixed Workloads	2022	SIGMOD	4.9224958e-05
8,106	Resumable Online Index Rebuild in SQL Server	2017	VLDB	4.5847706e-05
8,731	Columnar Formats for Schemaless LSM-based Document Stores	2022	VLDB	4.4577278e-05
10,786	Freely Moving Between the OLTP and OLAP Worlds: Hermes – an High-Performance OLAP Accelerator for MySQL	2025	VLDB	4.1945683e-05
12,063	Microsoft SQL Server’s Integrated Database Approach for Modern Applications and Hardware	2013	VLDB	4.1945683e-05

Outgoing Citations (Sorted by Pagerank)

Showing 6 of 6 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
21	C-Store: A Column-oriented DBMS	2005	VLDB	0.00086087497
35	MonetDB/X100: Hyper-Pipelining Query Execution	2005	CIDR	0.00076197749
123	A Decomposition Storage Model	1985	SIGMOD	0.00045255007
710	Performance Tradeoffs in Read-Optimized Databases	2006	VLDB	0.00017765454
1,949	Positional Update Handling in Column Stores	2010	SIGMOD	9.9864085e-05
2,258	SQL Server Column Store Indexes	2011	SIGMOD	9.1678883e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
1,053	A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database	2009	SIGMOD	0.00014429683
121	Improved Query Performance with Variant Indexes	1997	SIGMOD	0.00045447517
4,445	The Impact of Columnar In-Memory Databases on Enterprise Systems: Implications of Eliminating Transaction-Maintained Aggregates	2014	VLDB	6.1808093e-05
5,376	Holistic Indexing in Main-memory Column-stores	2015	SIGMOD	5.5417421e-05
1,590	Column-oriented Database Systems	2009	VLDB	0.00011233838
11,572	Workload-Aware Column Imprints	2020	SIGMOD	4.1945683e-05
6,336	Column Stores For Wide and Sparse Data	2007	CIDR	5.1056582e-05
497	Column-Stores vs. Row-Stores: How Different Are They Really?	2008	SIGMOD	0.00021716559
2,312	Real-Time Analytical Processing with SQL Server	2015	VLDB	9.0530853e-05
2,258	SQL Server Column Store Indexes	2011	SIGMOD	9.1678883e-05