Sniff
If you’re starting from scratch with column store, here are some links that’ll help you get a better understanding of how they work, and what they’re good for, start here.
For some background information on column store indexes, see …
Category: Stack Column Store
Stack Overflow Demo Database Column Store Edition: Exploring Relationships
Special Relativity
To get you started exploring the Stack Overflow column store database, here are some queries that show how tables are related.
The two main relationships are User Id, and Post Id.
User Id
/*User Id*/ SELECT COUNT_BIG(*) AS…
Stack Overflow Demo Database Column Store Edition: Downloads And Links
Gett Itt
If you want to download the database, here’s the magnet link for the torrent. I don’t have another means of distributing this; it’s too big of a file.
If you want the GitHub scripts to create and …
Stack Overflow Demo Database Column Store Edition: Making It Bigger
Stack Over Sharing
Rather than an F5 script to do this, I decided to make a stored procedure out of it. It’s in good shape, but if you find any problems or have any requests, head over to my GitHub …
Stack Overflow Demo Database Column Store Edition Introduction
In The Way Back Machine
I really wanted a version of the Stack Overflow data dump that was all clustered column store. In SQL Server 2016, that didn’t really work because of restrictions around MAX data types. In 2017 it …