Skip to content
Category

Sql Server

14 articles

Unusual Parameter Sniffing: Big Problems with Small Data
Sql Server thg 9 2, 2026 5 phút đọc

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’...

By Huy Vũ
Coming in Entity Framework 9: Better Query Parameterization
Sql Server thg 9 2, 2026 3 phút đọc

Coming in Entity Framework 9: Better Query Parameterization

Hallelujah. With current versions of Entity Framework, when developers add a mix of parameters and specific values to their query like this: C# 12345 async Task<List<Post>> GetPosts(int id) => await context.Posts .Where( e => e.Title == ...

By Huy Vũ