Microsoft SQL Server 2008 R2 Unleashed- P247

Microsoft SQL Server 2008 R2 Unleashed- P247: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 | 2424 roles database roles deleting managing with SSMS 321-322 from heap 1144 managing with T-SQL 322 from index 1144 fixed-database roles 304-306 reclaiming space 1144 fixed-server roles 303-304 with LINQ to SQL CD 1801 OLAR CD 2095-CD 2096 indexes 1134-1135 public roles 306-307 leaf rows 1138-1139 switching 623 nonleaf rows 1139-1140 user-defined roles 307-309 row constructors 38 CD 1569-CD 1572 ROLLBACK 999 CD 1984 row estimation ROLLBACK TRAN 999 1016-1017 estimating access path costs rollback transaction statement CD 1736 1221-1228 ROLLUP operator CD 1561-CD 1562 evaluating SARG and join selectivity 1216-1221 root-level certificate 278 multiple indexes 1228-1236 round-earth data CD 1605 updating routers 1535 forward pointers 1146 row constructors 38 CD 1569-CD 1572 index statistics 1159-1160 Row Count Spool 1312 in-place updates 1145 Row ID RID locking level 1365 not-in-place updates 1145-1146 row-level compression 1117-1119 with LINQ to SQL CD 1802 row-level locking 1373-1374 ROWS_PER_BATCH hint CD 2165-CD 2166 ROW NUMBER function CD 1708-CD 1710 rowversion data type 749 1396-1399 paging results CD 1714-CD 1717 ROW_OVERFLOW_DATA 1109 partitioning by CD 1710-CD 1711 RPC remote procedure calls 1545 CD 2243 row offset table 1108-1109 RPO recovery point objective 2336 ROW OVERFLOW DATA 753 CD 2180 row-overflow pages 1109-1110 RSCM SSRS configuration @@ROWCOUNT CD 1683-CD 1684 databases CD 2187-CD 2188 ROWGUIDCOL 757 email and execution accounts CD 2189 ROWLOCK optimizer hint 1395 encryption CD 2189-CD 2190 rows overview CD 2186 in database pages Report Manager CD 2189 overview 1104-1105 scale-out architecture configuration sparse columns 1107-1108 CD 2190 sql_variant data type 1107 Web Service CD 2186-CD 2187 structure of 1105-1107 Windows Service CD 2186 CD 2180 secondary GAM SGAM 2425 CD 2180 CD 2190 RTO recovery time objective 2337 running traces monitoring 153-154 runtime measuring with datediff 1336-1337 runtime component .