List of Tables

Chapter 4: Gathering and Understanding Business Requirements before Creating Database Objects

Table 4-1: Availability and Yearly Downtime

Table 4-2: Windows Performance Counters

Table 4-3: Cashier Profile: Register Invoice Task

Table 4-4: Resource Bottleneck Threshold

Table 4-5: Cashier Profile

Table 4-6: Server Maximum Capacity

Chapter 5: Designing a Database to Solve Business Needs

Table 5-1: Modeling Terminology

Table 5-2: SQL Server 2005 Datatypes

Table 5-3: Integer Datatype Parameters

Table 5-4: Precision Datatype Parameters

Table 5-5: Required Datatype Examples

Table 5-6: Approximate Datatype Parameters

Table 5-7: String Datatype Terminology

Table 5-8: Datetime Attribute Parameters

Table 5-9: Binary Datatype Parameters

Table 5-10: Database Files

Chapter 6: Reading Microsoft SQL Server 2005 Data from Client Applications

Table 6-1: ADO.NET Namespaces

Chapter 7: Selecting the Data You Need

Table 7-1: Configuration Functions

Table 7-2: Column Alias Syntax

Table 7-3: Input Parameter Syntax

Chapter 8: Creating Views to Encapsulate Queries

Table 8-1: Sample Output for sp_depends

Chapter 9: Retrieving Data Using Programmable Objects

Table 9-1: Database Server Programs

Table 9-2: Types Used in CLR/SQL Functions

Chapter 10: Inserting Data in Microsoft SQL Server 2005

Table 10-1: Severity Levels

Table 10-2: Error Functions

Chapter 11: Deleting Data from Microsoft SQL Server 2005

Table 11-1: Parameters for the sp_addmessage Stored Procedure