More online operations available now – or soon
I show DDL commands in Azure SQL Database that can now run as online operations instead of blocking, size-of-data operations.
I show DDL commands in Azure SQL Database that can now run as online operations instead of blocking, size-of-data operations.
I address a popular theory that NOLOCK can substantially reduce locking overhead against #temp tables.
Tip : Give SQL Server users access to Extended Events