10:00 I always thought that the "batch mode on rowstore" Enterprise-edition SQL Server 2019 thing just meant that you could do this demo without needing to add the logically pointless columnstore temp table. It's a trick that I learned from Iztik Ben-Gann's Window Function book. It's looking like I'm extremely wrong. The tooltip at 12:58 blew my mind. I had no idea that batch mode scans of rowstore indexes were possible! Is this a compat level 160 thing? 2019 is 150 but your examples use 160.
10:00 I always thought that the "batch mode on rowstore" Enterprise-edition SQL Server 2019 thing just meant that you could do this demo without needing to add the logically pointless columnstore temp table. It's a trick that I learned from Iztik Ben-Gann's Window Function book. It's looking like I'm extremely wrong. The tooltip at 12:58 blew my mind. I had no idea that batch mode scans of rowstore indexes were possible! Is this a compat level 160 thing? 2019 is 150 but your examples use 160.
Yep, all sorts of neat stuff once you start poking. It would be nice if Microsoft gave you better control over these things.
I'm a loud and proud Data Darling!
This is an A+ comment
2:10 I thought that I was ready. I was not.
You can always hit pause until you have reached a sufficient level of preparedness.
i always find value in your content 😘 (i heard you like kissy face emojis)
😘🥰😍 are all acceptable