Query Performance Articles

Page 2 of 2 (24 articles)

1/5/2019 • EN

Optimize for Analytics (Should be a Database Configuration option)

A proposal for a new "Optimize for Analytics" database configuration option in SQL Server and Azure SQL Database to enhance performance for data warehousing workloads.

Azure SQL Database Database Optimization Execution Plans Query Performance SQL Server

Niko Neugebauer

11/21/2018 • EN

Announcing “Columnstore & Batch Execution Mode” Channel

Announcing a new YouTube channel focused on SQL Server Columnstore Indexes and Batch Execution Mode, featuring technical videos and interviews.

Batch Execution Mode Columnstore Indexes Database Optimization Query Performance SQL Server

Niko Neugebauer

4/30/2018 • EN

Tracing with XEvents in Azure SQL Database

A guide to using Extended Events (XEvents) for advanced tracing and diagnostics in Azure SQL Database, covering setup and specific use cases.

Azure SQL Database Database Monitoring Extended Events Query Performance SQL Tracing

Andreas Wolter

5/29/2013 • EN

Postgres Indexes – Expression/Functional Indexing

Explains how to use PostgreSQL expression and functional indexes to optimize queries using built-in functions or custom JavaScript functions.

Database Optimization Functional Indexes indexing postgresql Query Performance

Craig Kerstiens

Previous 1 2

Query Performance Articles

Optimize for Analytics (Should be a Database Configuration option)

Announcing “Columnstore & Batch Execution Mode” Channel

Tracing with XEvents in Azure SQL Database

Postgres Indexes – Expression/Functional Indexing

Select Language

We use cookies