Parameter Sniffing

2 articles

Read as a book

Sql Server Sep 18, 2026 4 min read EN VI

You Can Disable Parameter Sniffing. You Probably Shouldn’t.

During my parameter sniffing classes, people get a little exasperated with the complexity of the problem. Parameter sniffing is totally hard. I get it. At some level, it’d be great to just hit a magic button and make the whole thing go a...

Saved by: Huy Vũ

Sql Server Sep 2, 2026 5 min read

Unusual Parameter Sniffing: Big Problems with Small Data

Normally when we think about parameter sniffing, we think about a tiny data vs big data problem: the tiny data’s plan goes in first, and when we try to process big data, performance is terrible. But sometimes, it’s the exact opposite. I’...

Saved by: Huy Vũ