Drills

Pick a focused question that fits your time, stack, and interview goal.

3 results across 1 active filter

Page 1 of 1

Compare covering indexes and wide indexes

Designs a narrow covering index from predicates and ordering, then weighs eliminated lookups against storage, write overhead, cache efficiency, overlap, and maintenance cost.

SQLSQL Server

Concept questionMedium~7 min

Explain SARGable predicates and index usage

Writes predicates the optimizer can use as index search arguments, then proves the effect through plans and reads while balancing computed columns, composite indexes, and write overhead.

SQLSQL Server

Coding problemHard~35 min

Query a local business date with a SARGable UTC range

Converts local-day boundaries to UTC once, preserving correct daylight-saving behavior and index use on stored UTC timestamps.

SQLSQL Server