X hits on this document

84 views

0 shares

0 downloads

0 comments

21 / 42

Database Engine

Service Broker

HTTP Access

Database Tuning Advisor

Enhanced Read ahead and scan

Indexes with Included Columns

Multiple Active Result Sets

Persisted Computed Columns

Try/Catch in T-SQL statements

Common Table Expressions

Server Events

Snapshot Isolation Level

Partitioning

Synonyms

Dynamic Management Views

.NET Framework

Common Language Runtime Integration

CLR-based Types, Functions, and Triggers

SQL Server .NET Data Provider

Data Types

CLR-based Data Types

VARCHAR(MAX), VARBINARY(MAX)

XML Datatype

Database Failure and Redundancy

Fail-over Clustering (up to 8 node)

Database Mirroring

Database Snapshots

Enhanced Multi-instance Support

XML

New XML data type

XML Indexes

XQUERY Support

XML Schema (XSD) support

FOR XML PATH

XML Data Manipulation Language

SQLXML 4.0

Database Maintenance

Backup and Restore Enhancements

Checksum Integrity Checks

Dedicated Administrator Connection

Dynamic Configuration AWE

Highly-available Upgrade

Online Index Operations

Online Restore

Management Tools

MDX and XML/A Query Editor

Maintenance Plan Designer

Source Control Support

Profiler access to non-sa

SQLCMD Command Line Tool

Database Mail

Performance Tuning                     

64-bit (IA-64 and XA-64)

Profiling Analysis Services

Exportable Showplan and Deadlocks

Profiler Enhancements

New Trace Events

Full-text Search

Backup/Restore includes FT catalogs

Multi-instance service

SQL Client .NET Data Provider

Server Cursor Support

Multiple Active Result Sets

Security

Catalog and meta-data security

Password policy enforcement

Fine Grain Administration Rights

Separation of Users and Schema

Surface Area Configuration

Notification Services

Embed NS in existing application

User-defined match logic

Analysis Services Event Provider

Replication

Seamless DDL replication

Merge Web Sync

Oracle Publication

Peer to Peer Transactional replication

Merge replication perf and scalability

New monitor and improved UI

Analysis Services and Data Mining

Analysis Management Objects

Windows Integrated Backup and Restore

Web Service/XML for Analysis

Integration Services and DM Integration

Eight new Data Mining algorithms

Auto Packaging and Deployment

Migration Wizard

Integration Services

New high performance architecture

Visual design and debugging environment

Extensible with custom code and scripts

XML task and data source

SAP connectivity

Integrated data cleansing and text mining

Slowly changing dimension wizard

Improved flow control

Integration with other BI products

Reporting Services

Report Builder

Analysis Services Query Designer

Enhanced Expression Editor

Multi-valued Parameters

Date Picker

Sharepoint Web Parts

Floating Headers

Custom Report Items

XML Data Provider

Some SQLserver 2005 Features

Document info
Document views84
Page views84
Page last viewedSat Dec 03 07:29:38 UTC 2016
Pages42
Paragraphs1204
Words2919

Comments