qrdrsvc.exe (Queue Reader Agent), 175, 480
Quality assurance (QA), 537
quality management tools, 403–404
queries, 70–71
concurrency issues, 116–118
latches, 118–122
locks. See locks
replication baselines, 513
Database Tuning Advisor, 71–76, 73–76
distributed, 469–474, 470, 472–473
DMVs, 35, 54–55
exam essentials, 152
hints, 90–92
indexes. See indexes
iterative processes for, 116
performance issues, 87–88
plan guides for, 92–94
plans, 81
analyzing, 86–87
generating, 81–86, 82–83, 85
troubleshooting, 41
poorly performing, 76–77
DMVs, 79–81
plans for, 77–78, 77
traces for, 78
for quality data, 403
recompiling, 89–90
review questions, 153–162
summary, 151
for validation. See joins
Query Timeout option, 464
Queue Length counter, 229, 235
Queue Reader Agent (qrdrsvc.exe), 175, 480
queued updating subscriptions, 176, 429, 505
queues, Service Broker, 276