1.

What Are The New Features In Sql Server 2005 When Compared To Sql Server 2000?

Answer»

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

There are quite a lot of changes and enhancements in SQL Server 2005. Few of them are listed here :



Discussion

No Comment Found