Episode 180 - Computed Columns with PERSISTED and Indexed Expressions

We let a dice roll decide today's topic, and the winner ended up being: Computed Columns with PERSISTED and Indexed Expressions. We give our thoughts about it, best practices, pit falls, and tips.

Relevant links:

• SQL Server 2025 Preview RC1: Now Supporting Red Hat Enterprise Linux (RHEL) 10 | Microsoft Community Hub
• Specify computed columns in a table - SQL Server | Microsoft Learn
• Indexes on computed columns - SQL Server | Microsoft Learn