Microsoft SQL Server 2008 R2 Unleashed- P244: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 | 2394 IsSchemaBound parameter IsSchemaBound parameter 938 IsSubscribed property 728 IsSyncWithBackup property 728 IsTableFunction parameter 938 IsTornPageDetectionEnabled property 728 IsUpdatedColumn parameter SqlTriggerContext CD 1856 ITransactionLocal StartTransaction function 1345 J JavaScript Object Notation JSON CD 1803 CD 1811 JDBC Java Database Connectivity 281 287 job history viewing 468-469 job mail notifications SQL Server Agent Mail 442-443 job notifications 467-468 job schedules 465-467 job steps 462-465 Job System page SQL Server Agent 451 jobs creating with SQL Server Agent Mail 443 defined 449 managing in SQL Server Agent 461 job history 468-469 job notifications 467-468 job properties 461-462 job schedules 465-467 job steps 462-465 multiserver job management 476-477 scripting 474-475 JOIN clauses identifying for query analysis 1215-1216 join hints 1282-1283 join selectivity evaluating 1216-1221 joining columns 521-522 1184 strings 493 variables 493 joins 1241 determining optimal join order 1246-1247 hash joins 1244-1246 hybrid joins 1246 index joins 1234 1236 merge joins 1243-1244 nested loops joins 1242-1243 outer joins CD 1673-CD 1674 full outer joins CD 1680-CD 1682 nested outer joins CD 1679-CD 1680 WHERE clause versus CD 1675-CD 1679 processing strategies 1241-1242 hash joins 1244-1246 merge joins 1243-1244 nested loops joins 1242-1243 semi joins 1250 subquery processing 1248 correlated subqueries 1250-1251 IN ANY and EXISTS subqueries 1248 materialized subqueries 1248-1250 tuning guidelines 1540 for WHEN clauses MERGE statement CD 1554 JSON JavaScript Object Notation CD 1803 CD 1811 K KEEP PLAN 1284 KEEP REPLICATION 406 410 KEEPFIXED PLAN 1284 KERBEROS CD 1934 linked servers 2395 KEY INDEX CREATE FULLTEXT INDEX 2008 Key locking level SQL Server 1365 key management 339 341 database master keys 340-341 EKM Extensible Key Management 341-342 service master keys 340 key performance indicators KPIs CD 2082 CD 2173 key-range locking granularity .
