Microsoft SQL Server 2012 Performance Tuning Cookbook

Index

A

• actual execution plan
  • about / Working with actual execution plan
  • generating, steps / How to do it...
  • working / How it works...
• algebraization
  • algebraizationabout / Introduction

B

• blocking transaction
  • determining / How to do it..., How it works...
• bulk data
  • loading / Deleting and loading bulk data by splitting, merging, and switching partitions (sliding window)
  • loading, in sliding fashion / How to do it..., How it works...

C

• classification component, resource governor
  • classification component, resource governorabout / Introduction
• client statistics
  • about / Including and understanding client statistics, Getting ready
• clustered index
  • about / Increasing performance by creating a clustered index
  • heap / Heap
  • table scan / Table and Index Scan/Seek ...