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.
SQL SERVER – Computed Column and Conditions with Case Statement
How to write conditions with CASE statement in a computed column, using a simple AdventureWorks script you can adapt for any complicated logic.