SQL / T-SQL

Designing, writing and measuring SQL that holds under load: thinking in sets rather than loops.

Writing SQL that goes from ten rows to ten million without a hiccup requires a different way of thinking: describing sets rather than iterating over rows. This section presents the principles, the techniques, commented examples and disaster cases (hierarchies, permissions, valuation) to practise avoiding them.

Set-based programming in T-SQLGoal and principle of set-based programming in T-SQL: think in sets of rows rather than loops, and let the optimizer do the work.19 pages