[m0zg]

Not if you filter on clustered columns, like you should if you care about performance.

[wodenokoto]

True, but now we have moved pretty far from just saying "use a where clause".

"Partition your table and create clustered columns and filter on those"