THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Columnstore   (RSS)
  • SQL Server 2019 Aggregate Splitting

    The SQL Server 2019 query optimizer has a new trick available to improve the performance of large aggregations. The new exploration abilities are encoded in two new closely-related optimizer rules: GbAggSplitToRanges SelOnGbAggSplitToRanges The extended event query_optimizer_batch_mode_agg_split is provided to track when this new ...
    Posted to Page Free Space (Weblog) by Paul White on August 3, 2020
  • Geek City: Build a Big Table with a Columnstore Index

    I was looking all over to find a big table to use for my columnstore examples in my SQL Server 2012 book, and the only one I found was from someone at Microsoft and was not publicly available. When I demonstrate code in my writings, I like to have the code available for anyone to use, so that was no use. Finally I realized I was just ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on April 26, 2012
Privacy Statement