2018-05-03
802 reads
ColumnStore Index
Performance Comparison Between SQL Server 2014 and 2016
This article outlines the performance innovations in SQL Server 2016 for Columnstore Index and BatchMode Execution.
2018-02-22
11,069 reads
2018-01-04
881 reads
2015-08-27
1,281 reads
2015-08-13
1,397 reads
2015-08-03
3,382 reads
2015-05-19
1,520 reads
Column Store vs Row Store Indexes
How does a column store index compare to a (traditional)row store index with regards to performance
2016-12-30 (first published: 2015-05-14)
15,524 reads
Introducing the Columnstore Index
A brief overview of Columnstore index and its usage with an example
2014-08-07
8,332 reads
Columnstore Index Changes in SQL Server 2014
SQL Server 2012 introduced columnstore indexes, which can immensely improve the performance of OLAP queries. How were they updated and improved in SQL Server 2014?
2014-07-24
8,405 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers