Episode 180 - Computed Columns with PERSISTED and Indexed Expressions
From SQL Server Radio by Guy Glantser, Eitan Blumin
October 13, 2025 · 38 min · Episode 180
About this episode
The episode discusses Computed Columns with PERSISTED and Indexed Expressions, sharing thoughts, best practices, and tips.
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
People in this episode
Hosts: Guy Glantser, Eitan Blumin
Topics covered
- Computed Columns
- PERSISTED Expressions
- Indexed Expressions
- Best Practices
- SQL Server
Keywords
- Computed Columns
- PERSISTED
- Indexed Expressions
- SQL Server
- Best Practices
- Tips
Mentioned in this episode
Organizations: Microsoft Community Hub, Microsoft Learn
Products: SQL Server 2025 Preview RC1, Red Hat Enterprise Linux (RHEL) 10
More episodes of SQL Server Radio
- Episode 188 - Virtualization pitfalls and best practices with SQL Server · June 8, 2026 · 30 min
- Episode 187 - Transactional Replication Between Availability Groups · May 13, 2026 · 30 min
- Episode 186 - Automatic Index Compaction and New DB DevOps Tooling · April 13, 2026 · 31 min
- Episode 185 - The Liar's Dividend · March 9, 2026 · 36 min
- Episode 184 - The Role of the DBA is Dead (Again) · February 9, 2026 · 36 min
- Episode 183 - Azure SQL Managed Instance Next Gen · January 12, 2026 · 36 min
Explore listener stats, chart rankings, contacts and more on the SQL Server Radio podcast page.