@JoeObbish I'm a big fan of Sam Neill but the movies seemed like they were aimed at kids
@JoeObbish What did I do? I'm sat here listening to cicadas on a sunny afternoon minding my own business with a glass of lemon lime and bitters cordial, contemplating the meaning of life
@PaulWhite The way I interrupted your "that's so cute" remark was "Look at these mere mortals who get nervous at the idea of SQL Server questions. I become more powerful whenever someone asks me a question."
@sp_BlitzErik I'm not sure how relevant this is today, but at the time, I remember finding it hardest to learn about the configuration options. The other stuff I had to learn was reasonably well documented or intuitive,
I wasn't able to find a formal guarantee of this behavior, but I did find multiple examples — including a modified version of your original example — in which query optimization decisions appear to be made based on a guarantee that partition numbers are in order by value. Here's what I found:
Yo...
anyone else read that one? I can't understand how he draws that conclusion
@JoeObbish The examples only work/are valid if SQL Server has an internal guarantee that partition id direction correlates with partitioning value direction.