'Prove This Query Can't Go Faster.'

Victor Barajas asked a great question in class today: what do I do when people ask me to prove why a network-bound query can't run faster? Here's the answer.

[vossvoss]

Thanks for the enthusiasm in your answer Brent. I really enjoyed the class.

[Abu_Albaraa]

Excellent, I didn’t get that part in the live 😂

[joshsimar]

My favorite way that's not talked about much is to take your biggest table and cluster columnstore it. If you have a smart puller like SSMS it can pull the smaller dataset and unpack on the front-end if network is actually your problem.

[karthiksitharam]

It's sad how ORM took away DB powers in the name simplifying. DB thinks in set of work to be done. Programming languages think in terms of objects. ORM eat into the easy performance gains that can be achieved by DB optimization