Announcement of a technical workshop on SQL Server Columnstore Indexes, covering versions, features, and practical techniques.
Announcement of a pre-conference workshop on SQL Server Columnstore Indexes at SQLSaturday Cincinnati, covering versions, batch mode, and Azure Synapse features.
Analyzes if Batch Mode on Rowstore eliminates the need for Columnstore Indexes in SQL Server, comparing performance and compression.
Explores limitations of Batch Execution Mode on Rowstore Indexes in SQL Server, including heuristics and missing operators.
Explores the heuristics and conditions under which SQL Server's Query Optimizer decides to use Batch Mode execution for query processing.
Explores SQL Server 2019's new Batch Execution Mode for Rowstore indexes, covering basics, enabling it, and analyzing performance.
