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.
SQL SERVER – Unable to Start SQL When Service Account is Removed From Local Administrators Group. Why?
When the service account is removed from local Administrators group, SQL Server may not start. Here is why, and the minimal permissions it needs.
SQL SERVER – Running CHECKDB with Minimum Repair Level
CHECKDB found 39 consistency errors and said repair_allow_data_loss is the Minimum Repair Level, but the reader could not finish the repair. Here is my reply.