Office Hours: “Read This” Edition

Sometimes when people post questions at, the answer is just a link, nothing more, nothing less. It doesn’t make sense for me to rehash something that’s been covered really well online, and I want to link ’em to the best resource possible.

Petr: Huge slowdown of basic queries when using a partitioned table (Partition_Key = ‘YYYYMM’). Queries: select max(ID) from PartitionTable; select top (1) ID from PartitionTable order by ID desc; scans all partitions and then limits the result (Sort, Stream Aggreate). What with this?

Read this and this.

MyTeaGotCold: Outside of T-SQL and Postgres, what SQL implementations do