Refactoring SQL Applications

Index

A note on the digital index

A link in an index entry is displayed as the section title in which that entry appears. Because some sections have multiple index markers, it is not unusual for an entry to have several links to the same section. Clicking on any link will take you directly to the place in the text in which the marker appears.

Symbols

@@CPU_BUSY variable (SQL Server), Querying dynamic views

A

AboveThreshold( ) utility function, A Simple Example

ACID property, Multiplying service providers at the application level

aggregates, Comparing checksums in SQL, Comparing checksums in SQL, Simplifying Conditions, Using aggregates, Adding columns

checksums, Comparing checksums in SQL, Comparing checksums in SQL

denormalization and, Adding columns

simplifying, Simplifying Conditions

simplifying constructs, Using aggregates

array variables, Example 2: A conversion function

arrival rate, Service time and arrival rate–Increasing parallelism, Service time and arrival rate, Increasing parallelism, Increasing parallelism

assessment, Assessment–A Simple Example, A Simple Example, A Simple Example, SQL Tuning, the Traditional Way, SQL Tuning, the Traditional Way, SQL Tuning, the Traditional Way, SQL Tuning, the Traditional Way, SQL Tuning, the Traditional Way, SQL Tuning, Revisited, SQL Tuning, Revisited, Refactoring, First Standpoint–Refactoring, Second Standpoint, Refactoring, First Standpoint, Refactoring, Second Standpoint, Refactoring, Second Standpoint, Refactoring, Second Standpoint, Choosing ...