Hi Ron,

You can definitely use partition switching in combination with columnstore indexes. And that can be a great way to optimize mass updates.

During the time of the partition switch, the...

Why would you expect the rules of integer division to apply when the input data are not integers?

You...

Appreciate this was posted a while back, I ran the same queries (including the index creation) on SQL server 2019 on my Intel core7 (8 gen) Laptop. The estimated Execution...

Phil Parkin wrote:

Generalising your argument:

It's OK to discriminate, as long as the one discriminating is in the minority.

Are you comfortable with this?

Congratulations Phil. After years of silent lurking, you managed to...

Thanks, Damian!

In your sample query, you have no WHERE clause. This means you need to read and process all data from the table. Rowgroup elimination (sometimes mistakenly called segment elimination),...