Index

 

Please note that index links point to page beginnings from the print edition. Locations are approximate in e-readers, and you may need to page down one or more times after clicking a link to get to the indexed material.

 

A

ACID (Atomicity, Consistency, Isolation, Durability), 254

actions, 57

ad hoc queries, 297–298

ad hoc T-SQL, 267–271

ad hoc workloads, 297–298

Adamson, Christopher, 321

ADD EVENT argument, 32

ADO.NET framework, 311

AdventureWorks database, 10, 311, 354

AdventureWorks2012 database, 10

AdventureWorksDW2012 database, 10

affinity mask configuration, 149

aggregated data sets, 349–350

aggregation algorithms, 357

aggregations

considerations, 128

DISTINCT keyword, 142–143

hashing, 137–138

overview, 137

sorting, 137–138

Stream ...

Get Microsoft SQL Server 2014 Query Tuning & Optimization now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.