I am very particular when it comes to someone presenting and teaching any of the mechanics involved with mastering SQL Server. With that said, I sat and watched this entire video with eyes fixed on the screen because the teaching was both informative and enjoyable. I'm already very familiar with windowing functions, but some of her remarks gave me a different way of looking at what I already know, which only enhances my foundation. Thanks and great job, Christina!
My constructive criticism .... Please reduce the size of the presenter video part, and increase the size of the presentation portion of the video. SQL SERVER is of prime importance.
Great video, but I don't understand why at 28:02 the counts for the duplicated times are 3 instead of 2 (since there are two people who arrived at the same time). Can someone please explain?
Toly Gins Since COUNT(*) counts the number of matches (partition-wise) from the beginning of the partition up to the "mates" (ordering-wise) of the current element, the first record, "Geneva", gets counted for both 2nd and 3rd record (same partition, later ArrivalTime). Hence the 1-3-3 sequence in the _count column.
I am very particular when it comes to someone presenting and teaching any of the mechanics involved with mastering SQL Server. With that said, I sat and watched this entire video with eyes fixed on the screen because the teaching was both informative and enjoyable. I'm already very familiar with windowing functions, but some of her remarks gave me a different way of looking at what I already know, which only enhances my foundation. Thanks and great job, Christina!
Excellent, thanks for sharing great content
My constructive criticism .... Please reduce the size of the presenter video part, and increase the size of the presentation portion of the video. SQL SERVER is of prime importance.
Good explanation ! Great vbid!
Start at 4:56
Great video, but I don't understand why at 28:02 the counts for the duplicated times are 3 instead of 2 (since there are two people who arrived at the same time). Can someone please explain?
Toly Gins Since COUNT(*) counts the number of matches (partition-wise) from the beginning of the partition up to the "mates" (ordering-wise) of the current element, the first record, "Geneva", gets counted for both 2nd and 3rd record (same partition, later ArrivalTime). Hence the 1-3-3 sequence in the _count column.