⟩ Tell me 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 Failover Cluster.
1.Profiler being able to trace the MDX queries of the Analysis Server.
2.Peer-toPeer Replication
3.Database Mirroring
