Friday, 8 January 2016

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

There are quite a lot of changes and enhancements in SQL Server 2005. Few of them are listed here :
 Database Partitioning
 Dynamic Management Views
 System Catalog Views
 Resource Database
 Database Snapshots
 SQL Server Integration Services
 Support for Analysis Services on a a Failover Cluster.
 Profiler being able to trace the MDX queries of the Analysis Server.
 Peer-toPeer Replication
 Database Mirroring

No comments:

Post a Comment