Optimizing Database Performance Overview
 Designing Federated Database Servers
    Designing Partitions
    Designing Federated Database Servers for High Availability
    Backing Up and Restoring Federated Database Servers
 Database Design
    Logical Database Design
       Database Design Considerations: Data Types
    Physical Database Design
       RAID
          Developing a Drive Performance Strategy
          RAID Levels and SQL Server
          Comparing Different Implementations of RAID Levels
          About Hardware-Based Solutions
          About Windows NT- and Windows 2000-Based Disk Striping and Striping with Parity
          About Windows NT-Based Disk Mirroring and Duplexing
       Partitioning
       Data Placement Using Filegroups
          Placing Tables on Filegroups
          Placing Indexes on Filegroups
       Index Tuning Recommendations
       Optimizing Transaction Log Performance
       Optimizing tempdb Performance
       File Systems
 Query Tuning
    Analyzing a Query
       Graphically Displaying the Execution Plan Using SQL Query Analyzer
       Logical and Physical Operators
          Assert
          Aggregate
          Bookmark Lookup
          Clustered Index Delete
          Clustered Index Insert
          Clustered Index Update
          Clustered Index Scan
          Clustered Index Seek
          Collapse
          Compute Scalar
          Concatenation
          Constant Scan
          Cross Join
          Delete
          Deleted Scan
          Distinct
          Distinct Sort
          Distribute Streams
          Eager Spool
          Filter
          Flow Distinct
          Full Outer Join
          Gather Streams
          Hash Match
          Hash Match Root
          Hash Match Team
          Index Delete
          Index Insert
          Index Scan
          Index Seek
          Index Spool
          Index Update
          Inner Join
          Insert
          Inserted Scan
          Lazy Spool
          Left Anti Semi Join
          Left Outer Join
          Left Semi Join
          Log Row Scan
          Merge Interval
          Merge Join
          Nested Loops
          Parallelism
          Parameter Table Scan
          Remote Delete
          Remote Insert
          Remote Query
          Remote Scan
          Remote Update
          Repartition Streams
          Right Anti Semi Join
          Right Outer Join
          Right Semi Join
          Row Count Spool
          Sequence
          Sort
          Split
          Stream Aggregate
          Table Delete
          Table Insert
          Table Scan
          Table Spool
          Table Update
          Top
          Union
          Update
          Cursor Logical and Physical Operators
    Query Tuning Recommendations
    Advanced Query Tuning Concepts
       Understanding Nested Loops Joins
       Understanding Merge Joins
       Understanding Hash Joins
 Application Design
    Networking and Performance
       Named Pipes vs. TCP/IP Sockets
    Optimizing Application Performance Using Efficient Data Retrieval
    Effects of Transactions and Batches on Application Performance
    Effects of Stored Procedures on Application Performance
    Understanding and Avoiding Blocking
    Optimizing Distributed Queries
 Optimizing Utility and Tool Performance
    Optimizing Backup and Restore Performance
    Optimizing Bulk Copy Performance
    Optimizing DBCC Performance
 Optimizing Server Performance
    Optimizing Server Performance Using Memory Configuration Options
    Optimizing Server Performance Using I/O Configuration Options
    Optimizing Server Performance Using Windows NT Options
       Maximizing Throughput
       Configuring Server Tasking
       Configuring Virtual Memory