Putting everything in a JSON column is tempting. Here is what it costs in reads, type checks and null handling, and when to promote a property.
Indexing JSON Properties With Computed Columns
Improve indexing JSON properties with typed computed columns, matching paths, required SET options, and plan checks on your workload.
Unique Pairs in Either Order: Blocking A-B When B-A Exists
A plain unique index treats (1, 2) and (2, 1) as different rows. Two computed columns and one index fix that, and I test the awkward cases.
Computed Column UDFs: Why Every Query on the Table Goes Serial
A computed column that calls a scalar function can block parallel plans for queries that never read it. Here is how to spot it and test a fix.
Accent-Insensitive Searches: Finding Jose and José Together
Build accent-insensitive searches with explicit collations, compare case rules, and index a computed search column for consistent lookup.
SQL SERVER – Computed Column – PERSISTED and Performance
My computed column series in one list: PERSISTED versus non-persisted for storage and speed, and how an index on the column improves performance.
SQL SERVER – Computed Column – PERSISTED and Storage
How a computed column is created and why PERSISTED and storage go together: persisted columns take more space. Plus links to the whole series.