Chapter 2. How Does SQL Server Work?

Introduction

Servers and Versions

Installing SQL Server

Running SQL Server Services

Touring the SQL Server System Databases

Understanding the SQL Server Security System

Managing SQL Server Connections

Using the SQL Query Tools

Creating SELECT Queries

Creating and Querying Views

Implementing Business Rules

User-Defined (Aliased) Types

Implementing Constraints

Managing Databases and Queries with Batches and Scripts

The Query Optimizer and the Query Plan

Understanding the Buffer Cache

Executing Action Commands

Introducing Stored Procedures

Introducing Triggers

Using Transactions to Protect Data Integrity

Administrative Functions

Working with the Transaction Log

Summary