Learn T SQL With Erik Computed Columns

Publicado el: 29 abril 2026
en el canal de: Erik Darling (Erik Darling Data)

353

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

En esta página del sitio puede ver el video en línea Learn T SQL With Erik Computed Columns de Duración hora minuto segunda en buena calidad , que subió el usuario Erik Darling (Erik Darling Data) 29 abril 2026, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 353 veces y le gustó 30 a los espectadores. Disfruta viendo!

19,948

158