Option Is Best / Memory Grants Connected User Information Filegroup / Checks Poor / System CO Hardware / Projects / SQL SERVER / CHANGE MANAGEMENT Creating Solutions / Microsoft / SQL Server Service / /
Event
Bankruptcy / /
MarketIndex
Locking Information Viewing Blocking Information / /
OperatingSystem
Microsoft Windows / Windows Server 2008 / /
Organization
DATABASE INSTANCE Authentication Types SQL Authentication Windows Authentication SQL Versus Windows Authentication Authorizing Securables Server Securables Database Securables Permission Chains Cross Database Permission Chains Row Level Security Summary CHAPTER / Replication Setting Up Peer-to-Peer Replication Configuring Peer-to-Peer Replication Scripting Replication Monitoring Replication Replication Monitor Performance Monitor Replication DMVs sp_replcounters Summary CHAPTER / AL CHAPTER / SAN Systems Server Configuration Fragmentation Summary CHAPTER / Support SQLDumper.exe SQLDiag.exe Summary CHAPTER / Advisor Summary CHAPTER / Using Master and Target Servers Summary CHAPTER / CONTENTS CHAPTER / Performance After Upgrade Summary CHAPTER / WMI Multiserver Administration / Summary CHAPTER / CLR Integration Design Goals Summary CHAPTER / Instances External Activation Summary CHAPTER / Using WMI Multiserver Administration / /
Person
Sending Messages / Enabling Message / Back It Up Uninstalling / /
Position
Configuring SQL Server Service Broker / Overview SQL Server Service Broker / Maintenance Plans Maintenance Plan Wizard Maintenance Plan Designer / Governor / Query Resource Governor / Asynchronous Messaging SQL Service Broker / Manager The Page File Page Faults I/O Network Disks Storage Considerations Designing / Broker / Indexes Database Tuning Advisor / Server Hardware Management CPU x64 Cache Hyper-threading Multicore System Architecture Memory Physical Memory Physical Address Space Virtual Memory Manager / Configuration Manager / Manager Startup Parameters / Agent General / SERVICE BROKER / Resource Governor Using Resource Governor / CONTENTS Startup Stored Procedures Partially Contained Databases Troubleshooting Tools Dedicated Administrator / /
Product
Max Server / /
ProgrammingLanguage
SQL / Microsoft SQL Server / /
Technology
Peer-to-Peer / Data Warehouse System / Data Mining / SAN / Virtual Memory / Business Intelligence / /
CONTENTS INTRODUCTION xxxvii 1