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
Nesta página do site você pode assistir ao vídeo on-line Learn T SQL With Erik Computed Columns duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Erik Darling (Erik Darling Data) 29 Abril 2026, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 353 vezes e gostou 30 espectadores. Boa visualização!
