SQL Server Functionality

Featured

Functionality

SQL Server 6.5

SQL Server 7.0

SQL Server 2000

SQL Server 2005

SQL Server 2008

SQL Server 2008 R2

Backup/Recovery

Yes

Yes

Yes

Yes

Yes

Yes

Batch processing

Yes

Yes

Yes

Yes

Yes

Yes

BCP/Export/Import

Yes

Yes

Yes

Yes

Yes

Yes

Capacity planning

Yes

Yes

Yes

Yes

Yes

Yes

Clustering and redundancy design

Yes

Yes

Yes

Yes

Yes

Yes

Daily maintenance

Yes

Yes

Yes

Yes

Yes

Yes

Database maintenance plans, scheduling, alerts

Yes

Yes

Yes

Yes

Yes

Yes

DCL/DDL/DML

Yes

Yes

Yes

Yes

Yes

Yes

Devices, databases and logs – design, creation,
and updating

Yes

Yes

Yes

Yes

Yes

Yes

Disaster Recovery

Yes

Yes

Yes

Yes

Yes

Yes

Documentation – policies and procedures

Yes

Yes

Yes

Yes

Yes

Yes

DTS (Data Transformation Services)

Yes

Yes

Yes

——

——

——

Hardware/RAID

Yes

Yes

Yes

Yes

Yes

Yes

Indexing, index statistics updating and index
optimization

Yes

Yes

Yes

Yes

Yes

Yes

Install/Configure/Upgrade

Yes

Yes

Yes

Yes

Yes

Yes

Load balancing

Yes

Yes

Yes

Yes

Yes

Yes

Logical design (schema)

Yes

Yes

Yes

Yes

Yes

Yes

Migration

Yes

Yes

Yes

Yes

Yes

Yes

Monitoring, including DBCC (Database Consistency
Checking)

Yes

Yes

Yes

Yes

Yes

Yes

Network/OS

NT

NT, Win 2000

NT, Win 2000

Win

Win

Win

OLAP Services (pre-SSAS) Yes

Yes

——

——

——

——

OLAP (Data warehousing)

Yes

Yes

Yes

Yes

Yes

Yes

OLTP

Yes

Yes

Yes

Yes

Yes

Yes

Performance Tuning (Optimization)

Yes

Yes

Yes

Yes

Yes

Yes

Physical design

Yes

Yes

Yes

Yes

Yes

Yes

Query Optimization

Yes

Yes

Yes

Yes

Yes

Yes

Replication

Yes

Yes

Yes

Yes

Yes

Yes

Security (User) administration

Yes

Yes

Yes

Yes

Yes

Yes

SQL (T-SQL)

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server end of architecture (2-tier, 2½-tier,
3-tier & other n-tier)

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server end of ecommerce solutions

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server vendor relations

Yes

Yes

Yes

Yes

Yes

Yes

SSAS —— —— Yes Yes Yes Yes
SSIS —— —— —— Yes Yes Yes
SSRS —— —— Yes Yes Yes Yes
Stored procedures, triggers, constraints, views

Yes

Yes

Yes

Yes

Yes

Yes

Tables, fields (columns), records (rows) –
creation and updating

Yes

Yes

Yes

Yes

Yes

Yes

Troubleshooting

Yes

Yes

Yes

Yes

Yes

Yes