Microsoft SQL Server 2008 R2 Unleashed- P240: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 | 2354 access check cache bucket count configuration option access check cache bucket count configuration option CD 2284 access check cache quota configuration option CD 2285 access path costs estimating 1221-1222 clustered indexes 1222-1223 nonclustered indexes 1223-1227 table scans 1227-1228 Account Provisioning page SQL Server Installation Center 205-206 accounts for Database Mail creating 429-432 SQL Server Agent proxy accounts 455-456 startup accounts for SQL Server Agent 452-453 ACID properties 996 @action parameter CD 2013 actions SSEE 1459 active multisite DR pattern CD 2334 active active configuration DR sites pattern CD 2333-CD 2334 SQL Server Clustering 657 active passive configuration DR sites pattern CD 2332-CD 2333 SQL Server Clustering 657 ActiveX Data Object Multidimensional ADO MD CD 2032 CD 2077 Activity Monitor 75-77 1483 ad hoc distributed queries configuration option CD 2285 adapters SSIS Attunity CDC Suite CD 2147 Add-Content cmdlet 491 ADD COLUMN clause 767 ADD parameter ALTER FULLTEXT INDEX CD 2011-CD 2012 AddHours method 502 adding CLR functions to databases 944-945 CLR stored procedures to databases CD 1780-CD 1781 columns T-SQL 767-768 counters 1469 data sources to OLAP databases CD 2044-CD 2046 extended stored procedures to SQL Server CD 1782-CD 1783 linked servers CD 2253-CD 2260 AddMilliseconds method 502 AddMinutes method 502 AddMonths method 503 AddSeconds method 503 AddYears method 503 administration tools SSMS 71 Activity Monitor 75-77 Log File Viewer 77 79 Object Explorer. See Object Explorer registered servers 71-72 SQL Server Utility 79-83 85 ADO MD ActiveX Data Object Multidimensional CD 2032 CD 2077 CD 1788-CD1793 CD 1804 CD 1810 Data Services ADODS CD 1787 CD 1803-CD 1805 building data services CD 1806-CD 1811 CRUD operations CD 1811-CD 1816 Advanced Encryption Standard AES 338 Advanced menu SQL Server Installation Center 211 Advanced page SQL Server Agent 451 Advanced Windowing Extensions AWE CD 2289-CD 2291 .
