Technical interview questions and drills

17 results across 1 active filter

Page 1 of 1

ADO.NET connection pooling and pool exhaustion

Explains physical connection reuse, pool partitioning, short ownership, exhaustion causes, diagnostics, and why increasing the pool is not the first fix.

.NETSQL Server

Practice drill

Coding problemMedium~25 min

Drills

ADO.NET connection pooling and pool exhaustion

Calculate a running account balance

Calculate seven-day rolling revenue

Compare covering indexes and wide indexes

Design reporting queries without hurting OLTP traffic

Diagnose blocking versus deadlocks

Diagnose the N plus one query pattern

Explain keyset pagination versus offset pagination

Explain SARGable predicates and index usage

Explain SQL Server parameter sniffing

Explain statistics, cardinality, and bad query plans

Find each user's longest login streak

Page orders with a stable keyset cursor

Query a local business date with a SARGable UTC range

Read an execution plan for a slow SQL query

Return the latest status for every order

Return the top three products in each category