Learn T SQL With Erik Computed Columns

Published: 29 April 2026
on channel: 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

On this page of the site you can watch the video online Learn T SQL With Erik Computed Columns with a duration of hours minute second in good quality, which was uploaded by the user Erik Darling (Erik Darling Data) 29 April 2026, share the link with friends and acquaintances, this video has already been watched 353 times on youtube and it was liked by 30 viewers. Enjoy your viewing!

306,476

8.8K