Timo van Zijll Langhout

@bgrainger I have some good news. My colleagues have figured out what caused the `KeyNotFoundException`! In this case, we were using a `TransactionScope` for the sole purpose of lowering the...

> The one thing worth emphasising is that TransactionScope (contrary to "regular" transactions) force use of MySQL distributed transactions which are not rolled back when connection dies. That seems like...

From the [recommended practices](https://learn.microsoft.com/en-us/dotnet/fundamentals/networking/http/httpclient-guidelines#recommended-use), we could choose the option of using a single, long-lived `HttpClient` around a `SocketsHttpHandler` with a relatively short `PooledConnectionLifetime`, such as 2 minutes. By creating the...

I think the following are worth taking into consideration for an implementation: - Avoid full table scans, since they are infeasible for many data sets. (`PARTITION OVER` loves to scan...

> @Timovzl have you seen the proposal https://github.com/dotnet/efcore/issues/25566#issuecomment-901062821? @roji Ah, yes, you had already proposed the dependent subquery. And to account for duplicate winners, we could adjust it to the...

> In any case, the precise translation of an operator after GroupBy or without GroupBy may differ, so these are possibly two slightly different conversations. I couldn't lay my finger...

> That sounds odd; I'd carefully test [the claim of subqueries having a greater constant overhead than joins] and share concrete, comparative queries and their plans. You're right. Based on...

I did some further research and discovered that it is fairly challenging to get SQL Server to use an optimal plan for `MAX`, even with a query that looks ideal....

I think the [SQL Fiddle for SQL Server](http://sqlfiddle.com/#!18/a63c5/5) I provided before should have been to reproduce things, right? Ok, except for the LINQ queries, I admit. In any case, your...

I've furthered my research on the above proposal for solving the groupwise min/max problem. I've managed to simplify it and confirm it to be efficient (even with composite keys and...