Posts tagged with

SQL

Discuss advanced indexing strategies beyond single-column indexes, such as covering indexes, filtered indexes, and columnstore indexes. Explain what index fragmentation is and how to address it.

Explain when it's appropriate to drop down to raw SQL or stored procedures with EF Core. Discuss the security implications (SQL injection) and how to prevent them.

Be able to analyze a query's execution plan and suggest improvements using indexes.

Explain the different isolation levels and the concurrency issues they prevent (dirty reads, phantom reads).