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