A Little About Computed Columns, Filtered Indexes, and Indexed Views in SQL Server

[@StanislavYanev]

I still don't understand why you have so few followers. You deserve 100x more. :)

[@ErikDarlingData]

Perhaps I need a new topic 😃

[@leebrownhill]

Lady Gaga may have her 'monsters' and Taylor Swift may have her 'swifties', but Erik has his Data Darlings!

[@ErikDarlingData]

I am sort of jealous of the monsters nickname though, hahaha

[@mohsensayadian]

Perfect as always

[@ErikDarlingData]

Glad you think so! Thanks for watching!

[@FlaggedStar]

07:06 I recall that some people like to use multi-table indexed views to enforce complicated constraints. I've never needed to do it, so I don't know if it's a good idea.

[@ErikDarlingData]

It works, but multi-table indexed views scare me.

[@FlaggedStar]

01:06 I can't wait for someone to complain about the column not being persisted.

[@ErikDarlingData]

I have prepared for that eventuality.

[@taylorjohnson5867]

I think it runs slightly faster if you do 0 = (select 0) ;)

[@ErikDarlingData]

Only if you cast them to bits 😃

[@neryanatanov385]

Why 1 = select (1)?😜

[@ErikDarlingData]

WHY YOU LITTLE

[@stephenlawrenson2380]

Joining Views I can live with. Nest views to n+1 levels and I am coming to hunt you down 😅

[@ErikDarlingData]

If you nest views deep enough you can eventually exhaust anyone to the point that nothing will get fixed.