Microsoft SQL Server 2008 R2 Unleashed- P245: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 | 2404 .NET Framework Code Access Security CAS permission sets CD 1827 data provider for SQL Server 280 283-284 namespaces CD 1788 NET SEND 459 NET START 118 NET STOP 118 net-libraries 280 network interfaces installing 668 monitoring 1478-1480 Network Load Balancing NLB extending MSCS with 662 network packet size configuration option CD 2306-CD 2307 network protocols. See protocols network shares 386-387 network tuning 1535 neural networks CD 2085 New Alert dialog 470 NEW BROKER 406 CD 1961 new implementations tuning methodology for 1523-1528 assessment stage 1524 coding and testing stage 1526-1527 identification and design stage 1525 implementation stage 1527-1528 prototyping stage 1525-1526 system testing and acceptance stage 1527 New Job Step dialog 462 new xml data type CD 1890-CD 1891 built-in methods CD 1899-CD 1918 exists method CD 1900 CD 1908-CD 1909 modify method CD 1900 CD 1913-CD 1918 nodes method CD 1900 CD 1911-CD 1912 query method CD 1900-CD 1908 value method CD 1900 CD 1910 columns CD 1892-CD 1894 FOR XML modes CD 1884-CD 1887 schema collections CD 1894-CD 1899 New-Object cmdlet 490 NEXT USED 783 NLB Network Load Balancing extending MSCS with 662 NO ACTION 818 NO CHECKSUM option BACKUP DATABASE 392 RESTORE DATABASE 405 NO COMPRESSION option BACKUP DATABASE 392 NO RECOVERY option RESTORE 630 NO TRUNCATE option BACKUP LOG 395 nodes 1303 failure of 679-681 in hierarchies CD 1589 XML documents CD 1866 nodes CD 1900 CD 1911-CD 1912 NOEXPAND 1236 NOLOCK 1394 NON-CLUSTERED argument CREATE INDEX 796 non-logged bulk-copy operations SSIS CD 2163-CD 2166 non-Transact-SQL non-T-SQL 455 Nonclustered Index Delete icon Query Analyzer 1309 Nonclustered Index Scan icon Query Analyzer 1310 Nonclustered Index Spool Query Analyzer 1312 nonclustered indexes 793-795 1112 1136-1138 costs 1223-1227 designing 1186-1188 OLAP online analytical processing 2405 leaf rows 1138-1139 nonleaf rows 1139-1140 rebuilding 1179 tuning guidelines 1540 nonexistent rows searching 1368-1369 .
