List of Tables

Chapter 13. SQL Server cost recovery

Table 1. The four basic models of chargeback

Table 2. Example of computational unit utilisation

Table 3. Sample chargeback calculation

Chapter 18. High availability of SQL Server in the context of Service Level Agreements

Table 1. Table of availability—the magic nines

Table 2. Table of high availability of SQL Server

Chapter 24. Extracting data with regular expressions

Table 1. Examples of reference lists in a document

Table 2. An example of extracted values

Table 3. Regular expressions matches

Table 4. Regular expressions groups

Table 5. Regular expressions groups utilizing grouping constructs

Table 6. The output columns corresponding to the result set of the core Match function

Chapter 29. Effective use of HierarchyId

Table 1. HierarchyId encoding standards

Chapter 31. Hardware 201: selecting and sizing database server hardware

Table 1. DDR3 ECC memory prices in late 2011

Chapter 33. Investigating the plan cache

Table 1. Columns of interest in sys.dm_exec_cached_plans

Table 2. Columns of interest in sys.dm_exec_cached_plans

Chapter 35. You see sets, and I see loops

Table 1. Partial query plan from SET STATISTICS PROFILE ON in listing 2

Table 2. Partial query plan from SET STATISTICS PROFILE ON in listing 3

Chapter 37. Strategies for unraveling tangled code

Table 1. Output of CTE

Table 2. Output of the complete query

Chapter 39. Tuning JDBC for SQL Server

Table 1. Summary of jTDS standard tuning items