User Manual

ManualsBrandsWiley Manualssoftware manualsSQL Server 2008 Administration Instant Reference

Part I: SQL Server Basics 1

Chapter 1: Installing SQL Server 2008 3

Prepare for Installation 4

SQL Server in the Enterprise 4

SQL Server Editions 9

SQL Server 2008 Licensing 16

Installation Requirements 17

Install SQL Server 2008 20

Performing a Standard Installation 21

Verifying a Standard Installation 32

Performing an Unattended Installation 37

Chapter 2: Configuring SQL Server 2008 41

Configure the Server Platform 42

Configuring System Memory 42

Planning System Redundancy 46

Configure SQL Server 2008 50

Configuring the Server with the SSMS 50

Configuring the Server with TSQL 64

Configuring the Services 66

Chapter 3: Creating Databases, Files, and Tables 75

Perform Capacity Planning 76

SQL Server I/O Processes 77

Disk Capacity Planning 79

Memory Capacity Planning 82

Create and Alter Databases 83

Create a Database 84

Alter a Database 92

Drop a Database 96

Manage Database Files 98

Add Files to a Database 98

Add Files to a Filegroup 101

Contents

Introduction xiii

96602book.indb 7 7/23/09 4:04:16 PM

COPYRIGHTED MATERIAL

Summary of content (5 pages)

PAGE 1
Contents xiii AL Introduction Chapter 1: Installing SQL Server 2008 TE D MA Prepare for Installation SQL Server in the Enterprise SQL Server Editions SQL Server 2008 Licensing Installation Requirements Install SQL Server 2008 Performing a Standard Installation Verifying a Standard Installation Performing an Unattended Installation TE RI Part I: SQL Server Basics GH Chapter 2: Configuring SQL Server 2008 1 3 4 4 9 16 17 20 21 32 37 41 42 42 46 50 50 64 66 Chapter 3: Creating Databases, Files,
PAGE 2
viii Contents Modify Database File Size Deallocate Database Files Create and Alter Tables Understand SQL Server Data Types Create a Table Alter a Table Drop a Table Chapter 4: Executing Basic Queries Use SQL Server Schemas Understand Schemas Create Schemas Associate Objects with Schemas Select Data from a Database Use Basic Select Syntax Group and Aggregate Data Join Data Tables Use Subqueries, Table Variables, Temporary Tables, and Derived Tables Modify Data Insert Data Delete Data Update Data Use the S
PAGE 3
Contents Chapter 6: Managing Transactions and Locks Manage SQL Server Locks Identify Lock Types and Behaviors Identify Lock Compatibility Manage Locking Behavior Manage Transactions Creating Transactions Handling Transaction Errors Using Savepoints in Transactions Implement Distributed Transactions Understanding Distributed Queries Defining Distributed Transactions Manage Special Transaction Situations Concurrency and Performance Managing Deadlocks Setting Lock Time-Outs Chapter 7: Managing Security Imple
PAGE 4
x Contents Implement Replication Understand Types of Replication Configure the Replication Distributor Configure the Replication Publisher Configure the Replication Subscriber Chapter 9: Extracting, Transforming, and Loading Data Use the Bulk Copy Program Utility Perform a Standard BCP Task Use BCP Format Files Use Views to Organize Output Use the SQL Server Import and Export Wizard Execute the Import and Export Wizard Saving and Scheduling an Import/Export Create Transformations Using SQL Server Integra
PAGE 5
Contents Chapter 12: Planning and Creating Indexes Understand Index Architecture Understand Index Storage Get Index Information Plan Indexes Create and Manage Indexes Create and Manage Clustered Indexes Create and Manage Nonclustered Indexes Use the Database Engine Tuning Advisor Manage Special Index Operations Cover a Query Optimize Logical Operations Optimize Join Operations Chapter 13: Policy-Based Management Understand Policy-Based Management Create a Condition Create a Policy Evaluate a Policy Policy