Question : I’m a bit of an SQL novice. I’ve been trying to create an auto generated column called TAG […]
When are computed columns computed?
Question : When are the values for computed columns determined? When the value is retrieved? When the value is changed? […]
How to create a Hash Computed Column for Many Columns?
Question : Does anyone know how to create a Hash Computed Column Persisted? I keep receiving an error below. Otherwise, […]
Table with persisted computed CLR originated data marked with has_unchecked_assembly_data = 1, but DBCC CHECKTABLE does not unset this same flag
Question : We have an OrderLines table with columns: Quantity int not null QtyCancelled int not null QtyBackorder int not […]
Intended use case for virtual columns with function-based index?
Question : What is the intended use case for virtual columns with a function-based index? The reason I ask (novice): […]
PostgreSQL: Generated Columns
Question : Does PostgreSQL support generated columns? Also know as virtual columns. I am not talking about IDENTITY columns. I […]
UPDATE failed because the following SET options have incorrect settings: ‘QUOTED_IDENTIFIER’ in Agent job
Question : In brief, I added a computed column to a table and then Agent jobs began failing and reporting […]
SQL Server FullText search on non-persisted columns
Question : Let’s say I have a table with 3 columns: Id, ColA and ColB. Then I created a FullText […]
Computed column cannot be persisted because the column is non-deterministic
Question : I know this is not the first time this type of question has been asked. But why in […]
Computed field when NULL
Question : I have two fields in my table : A int, B int. I want to add two computed […]