Microsoft SQL Server 2008 R2 Unleashed- P242

Microsoft SQL Server 2008 R2 Unleashed- P242: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 | 2374 databases moving 736 new features 710 OLAP database creation CD 2044 adding data sources CD 2044-CD 2046 ADO MD CD 2077 aggregating data within CD 2066-CD 2071 browsing data in the cube CD 2071-CD 2075 building and deploying the cube CD 2064-CD 2065 calculated members CD 2078-CD 2079 creating data source views CD 2046-CD 2050 creating the cube CD 2060-CD 2064 defining dimensions and hierarchies CD 2050-CD 2060 delivering data to users CD 2076 multidimensional expressions CD 2076-CD 2077 populating cubes with data CD 2065-CD 2066 query analysis and CD 2079-CD 2081 pages. See pages databases relational databases generating CD 2081 limitations of CD 2082 ReportServer CD 2180 ReportServerTempDB CD 2180 restoring. See restores rows. See rows safeguarding prior to making mass changes 1053 setting up for FILESTREAM storage CD 1596 shrinking 731 DBCC SHRINKDATABASE 731-732 DBCC SHRINKFILE 732-733 log files 734 in Maintenance Plan Wizard 1076-1077 with SSMS 734-735 snapshots. See database snapshots system databases 709 associated database files 167 distribution database 168 explained 166-167 maintaining 169-170 master database 167 model database 168 msdb database 168 resource database 168 tempdb database 169 tables. See tables tuning guidelines 1537 user databases 709 Datacenter Edition SQL Server 2008 42-43 DATAllegro v3 CD 2094 datasets CD 2193-CD 2194 shared datasets CD 2175 CD 2194-CD 2195 DATA_COMPRESSION argument CREATE INDEX 799 date calculations PowerShell 502-503 T-SQL CD 1663-CD 1666 converting dates for comparison CD 1666-CD 1669 first day of month CD 1664 first day of quarter CD 1665 first day of year CD 1664 midnight for the current day CD 1665 Monday of the current week CD 1665 DATE data type 37 748 751 CD 1572 date data types 751 CD 1572-CD 1576 DATEADD function CD 1663 DATEDIFF function CD 1663 datediff function 1336-1337 defaults 2375 datetime data type 748 751 CD 1572 DATETIME2 data type 37 748 751 CD 1573 DATETIMEOFFSET data type 37 748 751 CD 1573 .