Select Page
Diagnostic Data for Synchronous Statistics Update Blocking

Diagnostic Data for Synchronous Statistics Update Blocking

Consider the following query execution scenario: You execute a SELECT query that triggers an automatic synchronous statistics update. The synchronous statistics update begins execution and your query waits (is essentially blocked) until the fresh statistics are generated. The query compilation ... continue reading
Pearl Abyss: Massive Scale using Azure SQL Database

Pearl Abyss: Massive Scale using Azure SQL Database

Pearl Abyss is a Korea based game development studio established in 2009. Black Desert Online, a PC-massively multiplayer online role-playing game (MMORPG), is their main title in production published across the globe. On February 28, 2018, Pearl Abyss launched Black ... continue reading
Migrating to Azure SQL Database with Zero Downtime for Read-Only Workloads

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

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
ie_image_1

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