Microsoft SQL Server 2008 R2 Unleashed- P8: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 | 24 CHAPTER 1 SQL Server 2008 Overview SQL Server 2008 Standard Edition includes the following features CLR procedures functions and data types SQL Server Analysis Services Service Broker Reporting Services SQL Server Integration Services Full-Text Search Built-in XML support Spatial Indexes SQL Server Profiler and performance analysis tools SQL Server Management Studio Policy Based Management Replication Two-node failover clustering Database mirroring safety full mode only Log shipping Backup Compression available in R2 only The Standard Edition can be installed on any of the Windows 2003 SP2 and Windows 2008 Server platforms as well as Windows XP Professional Windows Vista Ultimate Enterprise or Business Editions and Windows 7 Ultimate Enterprise or Professional Editions. The Standard Edition should meet the needs of most departmental and small- to mid-sized applications. However if you need more scalability availability advanced security or performance features or comprehensive analysis features you should implement the Enterprise Edition of SQL Server 2008. SQL Server 2008 Enterprise Edition The Enterprise Edition of SQL Server 2008 is the most comprehensive and complete edition available. It provides the most scalability and availability of all editions and is intended for systems that require high performance and availability such as large-volume websites data warehouses and high-throughput online transaction processing OLTP systems. SQL Server 2008 Enterprise Edition supports as much memory and as many CPUs as supported by the operating system on which it is installed. It can be installed on any of the Windows 2003 SP2 and Windows 2008 Server platforms. In addition SQL Server 2008 Enterprise Edition provides performance enhancements such as parallel queries indexed views and enhanced read-ahead scanning. Download from SQL Server 2008 R2 Editions 25 Which version is right for you The next section explores the feature sets of Enterprise and .
