Development

  1. Home
  2. Development
  3. (Page 22)

Simon Sabin’s talk on query performance

Execution Plans
1 Comment
At #SQLbits, Simon Sabin (Twitter) talked about car crash queries: queries that suddenly have bad performance out of nowhere, yet if you copy/paste them into SQL Server Management Studio, they run quickly.  The culprit is often parameter sniffing: the engine looks at the query and builds a plan, but if the parameters in the WHERE…
Read More
Menu