About three years ago, SQL Server 2022 introduced Parameter-Sensitive Plan Optimization (PSPO). At the time, I explained that it didn’t work particularly well, and went so far as to pronounce PSPO in a rather unflattering way. I wouldn’t...
By Huy Vũ
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ũ
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ũ