Тёмный

A Little About Filtering On Dates In SQL Server 

Erik Darling (Erik Darling Data)
Подписаться 4,9 тыс.
Просмотров 871
50% 1

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

Опубликовано:

 

22 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 19   
@alexeybozrikov2413
@alexeybozrikov2413 2 месяца назад
That mentioning of people converting dates to varchar for joins truly hit the spot for me. Developers at my last permanent job just loved it. Thanks for another valuable video and good advice, I'll pass it on. 👍👍👍
@ErikDarlingData
@ErikDarlingData 2 месяца назад
Hahaha, I die a little every time I see someone doing that. Glad you enjoyed it though!
@Garstor
@Garstor 2 месяца назад
Query tuning through interpretive dance.
@ErikDarlingData
@ErikDarlingData 2 месяца назад
Kate Bush would have made a great perf tuner.
@gdonufrio
@gdonufrio 2 месяца назад
thank you! thumbs up as always! 😀👍
@ErikDarlingData
@ErikDarlingData 2 месяца назад
Thank you too! Appreciate you watching.
@zalmar5855
@zalmar5855 2 месяца назад
Love your daily knowledge-nuggets Erik, please never stop. Greetings from Hungary.
@ErikDarlingData
@ErikDarlingData 2 месяца назад
Hello! I have many Horvaths on my grandmother's side of the family. I hope to visit someday.
@mohsensayadian
@mohsensayadian 2 месяца назад
Nice, I have to watch the entire series from the beginning.
@ErikDarlingData
@ErikDarlingData 2 месяца назад
May you live to be 1000!
@CoryEllingson
@CoryEllingson 2 месяца назад
I love this. Things I just don't consider...
@ErikDarlingData
@ErikDarlingData 2 месяца назад
I will do my best, hahaha
@jg7734
@jg7734 2 месяца назад
Not positive and not negative: This comment is neutral. Topics like this just reinforce the need to maintain datatype consistency. Thx.
@ErikDarlingData
@ErikDarlingData 2 месяца назад
I’m taking this as overwhelmingly positive 😃
@FlaggedStar
@FlaggedStar 2 месяца назад
It stuns me that YEAR() is still not sargable.
@ErikDarlingData
@ErikDarlingData 2 месяца назад
Well, neither is ISNULL, and all that has to do is find NULLs.
@douglascoats7081
@douglascoats7081 2 месяца назад
first joke written by my staff of chimpanzees with type writers: "Why did sql server need a banana?" "It needed help with its split functions" Ok the staff clearly has some biases in its jokes lol
@ErikDarlingData
@ErikDarlingData 2 месяца назад
Damn dirty apes.
@douglascoats7081
@douglascoats7081 2 месяца назад
@@ErikDarlingData i hired these baboons based on your suggestion geeez
Далее
Fundamentals of Selects
25:21
Просмотров 2,5 тыс.
A Little About Function Rewrites In SQL Server
9:24
7 Years of Software Engineering Advice in 18 Minutes
18:32
Solving one of PostgreSQL's biggest weaknesses.
17:12
Просмотров 205 тыс.
Debugging a Complex T-SQL Issue
1:00:54
Просмотров 6 тыс.