Q

queries

creating for projects, 323

execution plan for

actual execution plan, 459–462

estimated execution plan, 455–459

monitoring, 437–438

performance of

after upgrading, 72–74

considerations for, 343

query plan for, 455, 478–479

tuning

adding indexes, 508–512, 520–523

assessing query performance, 500–506

DTA recommendations for, 506–509, 512–520

waiting for memory grants, monitoring, 437

worst performing, finding, 417

Query Analyzer, 345

Query Governor, 88

query notification, SQL Native Client used by, 5

query plan

analyzing with SQL Trace, 479

partitioned table query plan, 478–479

viewing (Showplans), 455

query processing, phases of, 439–442

query processor, SSAS, 183

Quests' Benchmark Factory, 378

Queue Monitor, Service Broker, 237

Queue Reader Agent, replication using, 531

queues, in Service Broker

altering, 220, 221

associated stored procedure with, 236

creating, 219–221, 225

definition of, 218–219

disabled, 271

managing, 258

Quinn, Stephen R. (Professional SQL Server Analysis Services with MDX), 181

quorum

for clustering, 658–659

for database mirroring, 559