Urgent.News

What's breaking now, across thousands of outlets.

More in Tech

Why Is My SQL Query Slow Only in Production? (The Parameter Sniffing Trap)

It’s every developer's favorite Friday afternoon nightmare: A user complains that a feature in the app is hanging. You take the exact SQL query executed by the application, paste it into SQL Server…

  • Parameter sniffing causes slow SQL queries in production only
  • SQL Server compiles execution plan based on initial parameter values
  • Detect problematic plans using dynamic management view (DMV)

More from Monday 10 August →