C#

How can this SQL query be optimized to the maximum?

Middle

Pyrus

// slice for all sensors, only the latest value by time // collection of anonymous objects, string double var result = list.GroupBy(x => x.Name) .Select(x => new { Name = x.Key, Value = x.OrderByDescending(g => g.Date).First().Value });

What is the computational complexity of this query? Can it be sorted in a single pass?

Middle

Pyrus

What is IQueryable and when is the query executed?

What is IDisposable used for?

What is MVCC?

What is the role of query execution plans in SQL and why are they needed?

How do you use the Singleton pattern in plugin architecture? How to organize the relationship between plugins?

Middle+

Тензор

Can you compare RabbitMQ and Kafka? For what tasks would you use each?

What are the advantages of NoSQL databases over relational ones? What is the CAP theorem?

Did you decompose tasks yourself or delegate decomposition to other developers?

Tell me about Redis — what are its features?

Tell about one of the recent interesting or complex tasks.

Decoding ACID?

Does async/await always work in a separate thread? Where do threads come from?

Middle+

Тензор

What is the difference in memory usage between a class and a struct?

Is it possible to determine externally whether a method is implemented via yield or via List?

Middle

Pyrus

What is DI (Dependency Injection) and why is it needed?

How does asynchronous programming differ from multithreading?

What are action filters?