DiscoverSQL Server RadioEpisode 180 - Computed Columns with PERSISTED and Indexed Expressions
Episode 180 - Computed Columns with PERSISTED and Indexed Expressions

Episode 180 - Computed Columns with PERSISTED and Indexed Expressions

Update: 2025-10-13
Share

Description

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:

Comments 
In Channel
Episode 182 - Matan Yungman's Show-and-Tell of Rapido

Episode 182 - Matan Yungman's Show-and-Tell of Rapido

2025-12-0840:40

Episode 181 - The new SSMS is still blue

Episode 181 - The new SSMS is still blue

2025-11-1033:23

Episode 180 - Computed Columns with PERSISTED and Indexed Expressions

Episode 180 - Computed Columns with PERSISTED and Indexed Expressions

2025-10-1337:55

Episode 179 - SQL Server 2025 RC0 announced and weird latch timeouts

Episode 179 - SQL Server 2025 RC0 announced and weird latch timeouts

2025-09-0834:40

Episode 178 - AI is another thing to babysit

Episode 178 - AI is another thing to babysit

2025-08-1136:50

Episode 177 - Five and a Half Enhancements in SQL Server 2025

Episode 177 - Five and a Half Enhancements in SQL Server 2025

2025-07-0729:18

Episode 176 - SQL Server 2025 and more

Episode 176 - SQL Server 2025 and more

2025-06-0938:14

Episode 175 - Migrating from on-prem to AWS RDS

Episode 175 - Migrating from on-prem to AWS RDS

2025-05-1238:59

Episode 174 - Is SQL Server quality in decline? Or is it just friction?

Episode 174 - Is SQL Server quality in decline? Or is it just friction?

2025-04-1432:37

Episode 173 - SQL Noir and the fate of Azure Data Studio

Episode 173 - SQL Noir and the fate of Azure Data Studio

2025-03-1034:36

Episode 172 - Between SQL Squid Games and SSMS

Episode 172 - Between SQL Squid Games and SSMS

2025-02-1031:25

Episode 171 - Clueless about SQL Server 2025

Episode 171 - Clueless about SQL Server 2025

2025-01-1332:08

Episode 170 - Interesting topics from PASS 2023 sessions

Episode 170 - Interesting topics from PASS 2023 sessions

2024-12-0934:10

Episode 169 - Resumable Incremental Database Integrity Checks

Episode 169 - Resumable Incremental Database Integrity Checks

2024-11-1132:36

Episode 168 - New data types in SQL Server and a question about index fragmentation

Episode 168 - New data types in SQL Server and a question about index fragmentation

2024-10-1432:49

Episode 167 - Let's Troubleshoot SQL AG Synchronization Latency

Episode 167 - Let's Troubleshoot SQL AG Synchronization Latency

2024-09-0937:40

Episode 166 - DR Planning for SQL Server and Loading Large CSV Files

Episode 166 - DR Planning for SQL Server and Loading Large CSV Files

2024-08-1235:32

Episode 165 - News in Azure SQL and Woes of Excel

Episode 165 - News in Azure SQL and Woes of Excel

2024-07-0838:44

Episode 164 - The Good the Bad and the Ugly Transactional Replication

Episode 164 - The Good the Bad and the Ugly Transactional Replication

2024-06-1035:32

Episode 163 - When and Why to HADR

Episode 163 - When and Why to HADR

2024-05-1334:37

loading
Google Play
Download from Google Play
Castbox
Download from App Store
usUnited States
00:00
00:00
x

0.5x

0.8x

1.0x

1.25x

1.5x

2.0x

3.0x

Sleep Timer

Off

End of Episode

5 Minutes

10 Minutes

15 Minutes

30 Minutes

45 Minutes

60 Minutes

120 Minutes

Episode 180 - Computed Columns with PERSISTED and Indexed Expressions

Episode 180 - Computed Columns with PERSISTED and Indexed Expressions

SQL Server Radio