Advantages of SQL server 2005 over SQL server 2000/ SQL server 7.0

• SQL server 2005 is exclusively designed for dot net developers. Whatever the function or procedure that we write in dot net environment those function or procedure that we directly execute in sql server environment. This is the new feature in SQL Server 2005.
• SQL Server 2005 has reduced application downtime, increased scalability and performance, and tight yet flexible security controls.
• SQL Server 2005 makes it simpler and easier to deploy, manage, and optimize enterprise data and analytical applications.
• It enables you to monitor, manage, and tune all of the databases in the effective way.
• Failure of the primary system, applications can immediately reconnect to the database on the secondary server using Database Mirroring.
• SQL Server 2005 provides a new capability for the partitioning of tables across file groups in a database.
• Has Features of XML, Multidimensional Expressions (MDX), and XML for Analysis (XMLA). Integration with the Visual Studio development environment provides more efficient development and debugging of line-of-business and business intelligence (BI) applications.