Columnstore Indexes – part 125 (“Estimate Columnstore Compression as a System Stored Proc”)
Read OriginalThis technical blog post, part 125 of a series, analyzes the updated sys.sp_estimate_data_compression_savings procedure in SQL Server 2019 CTP 2.0, which now supports Columnstore and Columnstore Archival compression. It compares Microsoft's implementation to the author's own custom procedure, discussing technical limitations, testing methodology, and the performance impact of operations like MERGE on Columnstore Indexes.
Comments
No comments yet
Be the first to share your thoughts!
Browser Extension
Get instant access to AllDevBlogs from your browser
Top of the Week
1
The Beautiful Web
Jens Oliver Meiert
•
2 votes
2
When your coding agent doesn’t understand your project, you’ll get junk
Benjamin Cane
•
1 votes
3
LLM Use in the Python Source Code
Miguel Grinberg
•
1 votes
4
Wagon’s algorithm in Python
John D. Cook
•
1 votes
5
An example conversation with Claude Code
Dumm Zeuch
•
1 votes