Learn T SQL With Erik Computed Columns
In this video, I dive into the fascinating world of computed columns in SQL Server, exploring both their benefits and some common pitfalls. You'll see me test a long-standing bug related to persisted computed columns and filtered indexes, revealing that Microsoft has yet to address it despite years of complaints. Along the way, I delve into the importance of determinism when creating computed columns, especially those involving dates, and show you how to make them indexable using the 'convert' function with a specified culture or style argument. By the end, you'll understand why these columns are so useful for optimizing queries and improving performance, particularly in scenarios where dynamic expressions need to be indexed.
CHAPTERS
00:00:00 - Introduction
00:02:35 - Bug Check in SQL Server
00:06:03 - Computed Columns Overview
00:09:15 - Filtered Index with Computed Column
00:10:48 - Bug Persistence
00:13:01 - Date-Related Computed Columns
00:15:23 - Non-Deterministic Functions
00:17:28 - Conclusion
In questa pagina del sito puoi guardare il video online Learn T SQL With Erik Computed Columns della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Erik Darling (Erik Darling Data) 29 aprile 2026, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 353 volte e gli è piaciuto 30 spettatori. Buona visione!
