Thanks for this. I almost fell of my chair laughing - when I was a junior DW developer, contracted to a huge bank, I once made the naive comment of "why don't you just add a 'Not Specified' option to your account types, instead of using NULL - SURELY the developers are smart enough to keep the data clean"... Unfortunately the senior developer was in the room and didn't think I was funny, and I was almost escorted out of the building... You have to appreciate the lengths SQL, DW, and ETL developers have to go to, to keep data clean!!! The unsung heroes of the development game!! Thanks for a great episode. Loved this one!!
@xl2898
5 жыл бұрын
Couldn't agree more! How many times do we also get "but you don't look like you're doing anything!" ….
@manassehkisame6286
4 жыл бұрын
Wow..clever guy..this one item has given me so many sleepless night and in 4 minutes it's over! thanking you
@AlphaWatt
4 жыл бұрын
Bert, seriously thank you so much for the time to put together all the content you have in your channel. I’m not a Developer or a DBA, just an analyst who had to learn all this by reverse engineering others code. That approach is great and all but personally leaves me with so many performance questions. I’ve binged you’re channel like Netflix haha but because of that I’ve GREATLY improved the performance of my queries. Just wanted to say thank you and no matter how little a topic may seem to an expert like you, please keep making these tutorials. Even yesterday I used ISNULL to join with on what will be a very large table. 🤦♂️ I’ll be changing that in just a few minutes! Thanks from Texas!
@Osteomorphis
2 жыл бұрын
This is exactly what I needed. Thank you. I'm having to left join a third table where the first and second table, also connected earlier on a left join, is null. I think the solution you taught is the solution to what I was struggling with last week!
@macmcmillen6282
3 ай бұрын
That's a very cool solution. Thanks!
@SebastienRicher42
4 жыл бұрын
Very nice! Clear and concise, exactly the solution I was looking for! Subscribed! :D
@pankhuriverma8484
2 жыл бұрын
So, if left outer join and table A has null values and table B also have null values, so from table A also null value will not come right?
@Vishalkumar-vj7hx
5 жыл бұрын
I have a question Can candidate key can have null values ?
@yourfavouriterecipes505
Жыл бұрын
Is this applicable (adding ISNULL condition) only on tables having composite keys?
@MrDimesy77
3 жыл бұрын
Thanks for your video. I already had the coalesce solution but it wasn't going to work for what I need to do. 2nd version looks good
Пікірлер: 15