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