How can you see the scripts executing in sp_executesql without an extra SELECT result set? A reader asked me, and here is the simple answer.
Azure SQL Elastic Pools: Sharing Resources Across Many Databases
Evaluate Azure SQL elastic pools using overlapping database demand, pool limits, per-database bounds, and measured workload performance.
SQL SERVER – Why Edition Upgrade is Not Upgrading Edition of SQL Server?
A DBA friend ran Edition Upgrade from Standard to Enterprise, setup finished with no errors, yet SQL Server still showed Standard Edition. Here is why.
What is the Default Datatype of NULL? – Interview Question of the Week #131
What is the Default Datatype of NULL? Most people say NULL has no type. A quick SELECT INTO test shows which datatype SQL Server actually picks.
Documenting Computed Columns: Definitions, Persistence and Determinism
A column that says decimal(21,2) hides how it gets its value. Pull the formula, persistence, precision and index use from the catalog, and script it so it can be rebuilt.
SQL SERVER – Setup Rule: Microsoft .NET Application Security. The computer cannot access the Internet
SQL Server setup warned on the Microsoft .NET Application Security rule because the computer cannot access the Internet. Here is what it means and what to do.
Parse and Compile Time: Reading the First Line of STATISTICS TIME
Someone pastes a compile time of 24 ms and asks if the server is slow. Run it twice and watch the plan cache do its job.