While the CROSS JOIN is not used much, and, depending on the size of your data it can be dangerous, there are some uses for it. For example, you...
2019-10-03 (first published: 2019-09-23)
1,035 reads
I’ve always felt responsible for making such a big deal about the differences between estimated and actual plans. I implied in the first edition of the execution plans book...
2019-09-18 (first published: 2019-09-09)
550 reads
I love going to SQLSaturday events because I’m always asked questions that make me think. I was just at SQLSaturday Indianapolis (a great event, if you weren’t there, you...
2019-09-09 (first published: 2019-08-19)
315 reads
It’s a running joke among the more experienced (read, older) Microsoft Data Platform specialists as to whether you’re #teamprofiler or #teamexevents. I’m very much #teamexevents, but I really don’t...
2019-08-28 (first published: 2019-08-19)
717 reads