Select Page

Migrating to Azure SQL Database with Zero Downtime for Read-Only Workloads

Special thanks to MSAsset engineering team’s Peter Liu (Senior Software Engineer) and Shail Batra (Principal Software Engineering Manager) for sharing their migration story with the Azure SQL Database product team. Microsoft uses an internally written service called MSAsset to manage ... continue reading

Compatibility Level 140 is now the default for Azure SQL Database

Database compatibility level 140 is now the default for new databases created in Azure SQL Database across almost all public regions. As of this writing, there are already 539,903 databases in Azure SQL Database running in compatibility level 140. Questions ... continue reading

Database scoped optimizing for ad hoc workloads

SQL Server provides the “optimize for ad hoc workloads” server-scoped option that is used to reduce the memory footprint of single use ad hoc batches and associated plans. When enabled at the SQL Server instance scope, the “optimize for ad ... continue reading

Default compatibility level 140 for Azure SQL databases

As of this writing, the default compatibility level for new databases created in Azure SQL Database is 130. Very soon, we’ll be changing the Azure SQL Database default compatibility level for newly created databases to 140. The alignment of SQL ... continue reading

Public Preview of Compatibility Level 140 for Azure SQL Database

Today we are announcing the official public preview of compatibility level 140 in Azure SQL Database. Compatibility level 140 enables the following query optimizer changes: A trivial plan referencing Columnstore indexes will be discarded in favor of a plan that ... continue reading

Public Preview of Compatibility Level 140 for Azure SQL Database

Today we are announcing the official public preview of compatibility level 140 in Azure SQL Database. Compatibility level 140 enables the following query optimizer changes: A trivial plan referencing Columnstore indexes will be discarded in favor of a plan that ... continue reading

Introducing Interleaved Execution for Multi-Statement Table Valued Functions

For SQL Server vNext and Azure SQL Database, the Microsoft Query Processing team is introducing a new set of adaptive query processing improvements to help fix performance issues that are due to poor cardinality estimates. Improvements in the adaptive query ... continue reading

Introducing Batch Mode Adaptive Joins

For SQL Server 2017 and Azure SQL Database, the Microsoft Query Processing team is introducing a new set of adaptive query processing improvements to help fix performance issues that are due to inaccurate cardinality estimates. Improvements in the adaptive query ... continue reading

Introducing Batch Mode Adaptive Memory Grant Feedback

SQL Server uses memory to store in-transit rows for hash join and sort operations. When a query execution plan is compiled for a statement, SQL Server estimates both the minimum required memory needed for execution and the ideal memory grant ... continue reading