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)
Incoming Non-self Citations Over Time
Authors
- 1. Per-Åke Larson (Microsoft)
- 2. Cipri Clinciu (Microsoft)
- 3. Campbell Fraser (Microsoft)
- 4. Eric N. Hanson (Microsoft)
- 5. Mostafa Mokhtar (Microsoft)
- 6. Michal Nowakiewicz (Microsoft)
- 7. Vassilis Papadimos (Microsoft)
- 8. Susan L. Price (Microsoft)
- 9. Srikumar Rangarajan (Microsoft)
- 10. Remus Rusanu (Microsoft)
- 11. Mayukh Saubhasik (Microsoft)
BibTeX Citation
@inproceedings{larson_sigmod13,
title = {{Enhancements to SQL Server Column Stores}},
author = {Larson, Per-Åke and Clinciu, Cipri and Fraser, Campbell and Hanson, Eric N. and Mokhtar, Mostafa and Nowakiewicz, Michal and Papadimos, Vassilis and Price, Susan L. and Rangarajan, Srikumar and Rusanu, Remus and Saubhasik, Mayukh},
series = {{SIGMOD} '13},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/2463676.2463708},
url = {https://dl.acm.org/doi/10.1145/2463676.2463708},
year = {2013}
}
Incoming Citations (Sorted by Pagerank)
Showing 27 of 27 citing papers.
Previous
Page 1 / 1
Next
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 |
|---|---|---|---|---|
| 12 | C-Store: A Column-oriented DBMS | 2005 | VLDB | 0.00069513174 |
| 14 | MonetDB/X100: Hyper-Pipelining Query Execution | 2005 | CIDR | 0.0006312782 |
| 115 | A Decomposition Storage Model | 1985 | SIGMOD | 0.00032338948 |
| 630 | Performance Tradeoffs in Read-Optimized Databases | 2006 | VLDB | 0.00015591796 |
| 1,629 | Positional Update Handling in Column Stores | 2010 | SIGMOD | 0.00010184131 |
| 1,747 | SQL Server Column Store Indexes | 2011 | SIGMOD | 9.8494706e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 966 | A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database | 2009 | SIGMOD |
| 2 | 104 | Improved Query Performance with Variant Indexes | 1997 | SIGMOD |
| 3 | 3,902 | The Impact of Columnar In-Memory Databases on Enterprise Systems: Implications of Eliminating Transaction-Maintained Aggregates | 2014 | VLDB |
| 4 | 5,039 | Holistic Indexing in Main-memory Column-stores | 2015 | SIGMOD |
| 5 | 1,395 | Column-oriented Database Systems | 2009 | VLDB |
| 6 | 11,768 | Workload-Aware Column Imprints | 2020 | SIGMOD |
| 7 | 6,047 | Column Stores For Wide and Sparse Data | 2007 | CIDR |
| 8 | 345 | Column-Stores vs. Row-Stores: How Different Are They Really? | 2008 | SIGMOD |
| 9 | 1,692 | Real-Time Analytical Processing with SQL Server | 2015 | VLDB |
| 10 | 1,747 | SQL Server Column Store Indexes | 2011 | SIGMOD |