User Manual

Contents xi
Chapter 12: Planning and Creating Indexes 407
Understand Index Architecture 408
Understand Index Storage 408
Get Index Information 411
Plan Indexes 416
Create and Manage Indexes 419
Create and Manage Clustered Indexes 419
Create and Manage Nonclustered Indexes 426
Use the Database Engine Tuning Advisor 428
Manage Special Index Operations 431
Cover a Query 432
Optimize Logical Operations 433
Optimize Join Operations 435
Chapter 13: Policy-Based Management 437
Understand Policy-Based Management 438
Create a Condition 441
Create a Policy 443
Evaluate a Policy 446
Policy Storage 448
Troubleshooting Policy-Based Management 449
Manage Policies in the Enterprise 451
Benefits of the EPM Framework 451
Chapter 14: Automating with the SQL Server Agent Service 455
Configure the SQL Server Agent Service 456
Understand Automation Artifacts 456
Perform Basic Service Configuration 459
Configure Database Mail 465
Create and Configure Automation Objects 470
Create and Configure Proxies 470
Create and Configure Schedules 473
Create and Configure Operators 477
Create and Configure Alerts 479
Create and Configure Jobs 482
Use the SQL Server Maintenance Plan Wizard 488
Index 497
96602book.indb 11 7/23/09 4:04:17 PM