A Little About Working With Binary and Varbinary Data In SQL Server

Become a member! www.youtube.co...
Click here for 50% off a health check: training.erikd...
If you like what you see here, you'll love my advanced performance tuning training:
training.erikd...

[@BrandonChampion]

Postgres supports casting via 3 methods, and I've seen queries that combine all 3:
CAST(created_at AS DATE) , created_at::date , DATE created_at

[@ErikDarlingData]

I do like the brevity of the col::type syntax.

[@FlaggedStar]

I've needed to know what a query/plan hash is before, but I've never been so unlucky to need to know what a SQL handle is. When does it come up?

[@ErikDarlingData]

I talk about very specific cases for that in the video. Go ahead and give it another watch.

[@fpost337]

What the hell did I just watch?

[@ErikDarlingData]

✨✨✨ A RUclips video from world-renowned SQL Server expert Erik Darling on the intricacies of working with binary data types in SQL Server ✨✨✨