- New Functionalities in SQL Server 2008 (living document)

Welcome to Sign in | Help

New Functionalities in SQL Server 2008 (living document)

Reply Quote

Declarative Management Framework
Server Group Management
Streamlined installation
Enterprise System Management
Performance Data Collection
System Analysis
Data compression
Resource Governor
Query Optimization Modes
Extended Events
Logging Improvements (Minimal Logging = log only what is necessary for rollback)
Entity Data Model
Language Integrated Query (LINQ)
Visual Entity Designers
Entity Aware Adapters
SQL Server Change Tracking
Synchronized Programming Model
Visual Studio Support
SQL Server Conflict Detection
BLOBS in SQL SERVER 2008

Add to that:

Visual designer, and add nodes to a peer-to-peer replication configuration without stopping system activity
Performance Studio to troubleshoot, tune, and monitor
Table-valued parameters
Transact-SQL Row Constructors (Table-valued constructors)
Include Scalar Values in Row Constructors (
INSERT INTO MyTable (ColX,ColY)

VALUES ((SELECT Top 1 ColZ FROM MyOtherTable),

(SELECT Top 1 ColW FROM MyOtherTable));
)
One statement variable declaration/assignment
Compound Assignment Operators
HierarchyID data type
Deprecation Counters
Large User Defined Aggregates
New versions of ODBC driver, OLE DB provider, and ADO.NET data provider
SQLCE Version 3.5
Lock Escalation changes

Unconfirmed yet:

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

Filed under: Articles, SQL Server 2008