NULLs are interesting values. While they fill an important need in the database, it's not always intuitive how different SQL Server statements and functions handle them.
This week we examine how COUNTs and DISTINCTs interact with NULLs...and how they may not always be doing what you expect with them.
Subscribe and turn on notifications to never miss a weekly video: https://www.youtube.com/c/DataWithBer...
Related blog post with more examples:
https://bertwagner.com/2019/02/19/cou...
Follow me on Twitter:
/ bertwagner