Microsoft SQL Server 2008 R2 Unleashed- P248: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 | 2434 SSMS SQL Server Management Studio constraints creating 823-826 controls summary CD 2202-CD 2204 creating user-defined functions 930-933 data bars CD 2203 data compression managing 1126-1127 Database Diagram Editor 743-744 databases creating 718-721 database roles 321-322 restores 409-410 shrinking 734-735 disk performance monitoring 1490 enhanced features 45 explained 12-14 expressions CD 2200-CD 2202 gauges CD 2203 Image control CD 2203 indexes creating 800-803 managing 806-807 1183 indicators CD 2203-CD 2207 integrated help 68-70 integrating with source control 95-97 Line control CD 2203 Log File Viewer 77-79 logins deleting 317 managing 313-317 modifying 316 Map control CD 2203 memory monitoring 1486 Missing Index Hints 1320 multiserver queries 101-102 new features 41-42 63-64 Object Explorer 73-75 creating tables 742-743 data types 750 dropping tables 773-774 modifying tables with Table Designer 769-772 permissions managing at database level 326-328 at object level 328-329 at server level 323-325 plan guides creating and managing 1297-1298 project management 93-95 Query Analyzer 1302-1307 Query Editor disconnected editing 88 editing sqlmd scripts 88-89 IntelliSense 87 overview 85-87 performance 91-92 Query Designer 92-93 query types 87-88 regular expressions and wildcards 89-91 Rectangle control CD 2203 registered servers 71-72 reports. See reports resource pools creating 1500-1502 deleting 1515 security built-in roles and permissions CD 2234-CD 2235 role assignments CD 2234 security roles CD 2234 system roles and permissions CD 2235 Shrink File dialog 1036 Sparklines CD 2203-CD 2207 spatial data support in CD 1611-CD 1614 SQL Server Utility 79-85 SSRS SQL Server Reporting Services 2435 stored procedures. See stored procedures Subreport control CD 2204 subscriptions CD 2235-CD 2236 data-driven subscriptions CD 2236-CD 2237 delivery architecture CD 2237 T-SQL debugging 100-101 Tablix CD 2199-CD 2202 TDE transparent data encryption in 352-353 Template .
