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 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
• Episode 182 - Matan Yungman's Show-and-Tell of Rapido · December 8, 2025 · 41 min
• Episode 181 - The new SSMS is still blue · November 10, 2025 · 33 min

Explore listener stats, chart rankings, contacts and more on the SQL Server Radio podcast page.