The dashboard says the average is 1 when everyone can see it is 1.5. Here is why AVG does that and the one-line fix.
How to Find Definition of Computed Column in SQL Server using T-SQL? – Interview Question of the Week #233
Question: How to Find Definition of Computed Column in SQL Server using T-SQL?
Answer: A very fair question, I received the other day.
Indexed Computed Columns: Speeding Up Code You Cannot Change
Use indexed computed columns to help fixed vendor queries on UPPER or CAST, while checking determinism and required SET options.
JSON_MODIFY: Changing One Property Inside a JSON Column
Edit one value inside a JSON document without string surgery. A hands-on tour of the quirks with types, NULL, missing paths and retries.
Blind Index: Searching an Encrypted Column Without Decrypting
Encrypted emails cannot be searched, so store a keyed digest beside them. A hands-on demo of how it works, what it leaks and how rotation hurts.
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 – Columnstore Index Cannot be Created When Computed Columns Exist
A developer found a columnstore index cannot be created on a large history table in SQL Server 2014. The surprise cause: computed columns in the table.