9 articles
Hi. I’m a former developer who’s moved into database administration, and here’s what I wish somebody would have told me when I got started. 7. SQL functions rarely perform well. Good developers like to reuse code by putting it into funct...
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ũ