Microsoft SQL Server 2008 R2 Unleashed- P246:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 2414 processing processing processing hints 1282 1285 processing instructions XML CD 1866 reports CD 2176 snapshot agents 567-568 transactions 997 processor affinity 1481 CD 2286 processors monitoring 1480-1485 Product Key entry page SQL Server Installation Center 197-198 Profiler 132-135 1338-1340 1547 analyzing slow stored procedures or queries 157-158 application progress monitoring 162-164 architecture 122-123 auto-update statistics monitoring 162 deadlocks 158-159 1390-1392 explained 15 indexes selecting 1149 lock activity monitoring 1355-1357 new features 121 performance bottlenecks identifying 160162 queries identifying ad hoc queries 159-160 replaying trace data 138-140 traces analyzing trace output with Database Engine Tuning Advisor 138 creating 123-125 data columns 127-128 130 defining server-side traces 140-141 148-152 events 125-127 executing 132 exporting 132 filters 130-132 importing 135 importing into tables 135-136 saving 132 saving Profiler GUI output 134-135 saving to files 133 saving to tables 134 stopping server-side traces 155-156 trace events and categories 141-147 traces monitoring 153-154 user configurable events 163 profiles creating in Database Mail 429-432 PowerShell 487 projects managing in SSMS 93-95 properties. See specific properties PROPERTY secondary index XML 1923 protocols ensuring appropriate network protocols are configured on server 264-267 support for 191 prototyping stage tuning methodology 1525-1526 1531-1532 providers 280 defined 484 SQL providers 507 515 provisioning 268-270 proximity CD 2022 proxy accounts 455-456 public keys 338 public roles 306-307 publication server 549-550 publications 550 creating 584-592 data replication 550 Publisher role CD 2234 publisher subscriber replication model 558 publishing 581-584 pull subscriptions 563 Query Analyzer 2415 Q QA quality assurance HA high availability 528 testing database snapshots 1064 QNames CD 1941 qualifying names CD 1941 quality assurance QA HA high availability 528 .
