Microsoft SQL Server 2008 Bible

Preface

What Is a Sidebar?

Chapter 2: Fundamental SQL Concepts and Principles

ANSI/ISO Standard Documents

Chapter 3: SQL Data Types

Introducing Unicode

Character vs. Special Files

Precision and Scale for NUMERIC and DECIMAL Datatypes

Selecting Correct Data Types

Understanding TIMESTAMP WITH LOCAL TIME ZONE Data Type

Chapter 4: Creating RDBMS Objects

Using INITIALLY DEFERRED Constraints

Index Organized Tables and Other Physical Properties

Creating Summary Tables

Clustered Indexes

Simulating OR REPLACE Clause in MS SQL Server

Chapter 6: Data Manipulation Language (DML)

Archiving Based on Complex Business Rules

RDBMS error messages

Dangers of the WHERE Clause

Chapter 7: Sessions, Transactions, and Locks

Setting SQL*Plus Session Parameters

Orphaned Sessions

Explicit and Implicit Transactions

Nested Transactions

Distributed Transactions

Chapter 9: Multitable Queries

Fully Qualified Column Names

Chapter 10: SQL Functions

Getting Random Numbers in a Different Range

NULL and Aggregate Functions

Conversion Pitfalls

Chapter 11: SQL Operators

Why Operator Precedence Is Important

Using Boolean Logic for Data Safety

Chapter 12: SQL and RDBMS Security

Oracle 9i User PROFILE

SQL Server 2000 DENY Statement

OS Security Integration

How XOR Encryption Works

What Is C2 Security Level?

Chapter 13: The System Catalog and INFORMATION_SCHEMA

Getting Help

Chapter 14: Stored Procedures, Triggers, and User-Defined Functions

Sequential and Event-Driven Programming

Passing Parameters by Name and by Value

Chapter 15: Dynamic and Embedded SQL Overview

Embedded and Dynamic SQL Terminology

Embedded (Static) Versus Dynamic SQL: Advantages and Disadvantages

Chapter 16: SQL API

JDBC Connector and Java Data Objects (JDO)

Oracle Gateways

Microsoft DBLIB Legacy

Chapter 17: New Developments—XML, OLAP, and Objects

XML and Web Services

Future of XML

OLAP Rules

ROLAP, MOLAP, and HOLAP...

Collections and Arrays

Appendix L: A Brief Introduction to the Number Systems, Boolean Algebra, and Set Theory

Set Operations on Multielement Operands