SqlCredit – Part 12: Exploring Indexed Persisted Computed Columns

(Rob Garrison) SQL Server 2005 adds the option of “persisting” a computed column. Prior to SQL Server 2005, you could create a computed column, but it would not be stored on disk and could not be indexed. If a computed column was not persisted, it would be recalculated each time it is accessed, so y

Read More - Register for Free Membership