Columnstore Indexes – part 124 (“Estimate Columnstore Compression”)
Introduces a custom stored procedure for estimating compression savings for SQL Server Columnstore Indexes, filling a gap in native tooling.
Introduces a custom stored procedure for estimating compression savings for SQL Server Columnstore Indexes, filling a gap in native tooling.
Author shares excitement about being selected to speak at PASS Summit 2018 on SQL Server Columnstore index selection.
A deep dive into SQL Server Columnstore Index wait types, explaining their groups and providing setup for analysis.
Columnstore Indexes are now available on the Standard Tier of Azure SQL Database, enabling better compression and performance for data warehousing.
A deep dive into SQL Server's In-Memory technologies, including Columnstore Indexes and In-Memory OLTP, presented at a tech conference.