Domain: Query Writing and Optimization

Query Writing and Optimization

This domain owns how T-SQL is written and how workload behavior is optimized. It starts with language fundamentals, then moves into execution plans, Query Store, waits, blocking, deadlocks, and race conditions.

mindmap
  ((Query Writing and Optimization))
    (SELECT)
    (joins and subqueries)
    (CTEs and temp objects)
    (window functions)
    (strings and dates)
    (types and NULLs)
    (procedural T-SQL)
    (JSON and XML)
    (INSERT UPDATE DELETE OUTPUT)
    (MERGE and upsert)
    (SARGability)
    (execution plans)
    (Query Store)
    (wait stats)
    (blocking)
    (deadlocks)
    (race conditions)

SELECT, JOIN, and Result Shaping

01-select-and-query-basics

03-joins-subqueries-and-apply

04-common-table-expressions-and-temporary-objects

05-window-functions

Functions, Data Types, and Procedural T-SQL

07-string-functions-and-pattern-matching

08-date-and-time-functions

06-numeric-and-aggregate-functions

02-data-types-conversion-and-null-handling

15-system-functions-and-session-metadata

19-stored-procedures-dynamic-sql-and-error-handling

09-json-xml-and-semi-structured-data

10-insert-update-delete-patterns

11-merge-and-upsert

Query Optimization, Plans, and Workload Behavior

12-sargable-queries

13-execution-plans

20-query-store-regressions-and-plan-forcing

14-wait-stats-analysis

Blocking, Deadlocks, and Race Conditions

16-blocking-and-locking

17-deadlock-detection-and-prevention

18-race-conditions