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 filegroups 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
Above answer was rated as good by the following members: Arun Chowdary
RE: What are the advantages of sql server 2005 over sq...
Advantages includeEnterprise data managementBusiness Intelligenceyou can find more information on this athttp://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspxhttp://msdn2.microsoft.com/en-us/library/ms345147.aspxIntegation of all components and core databas engine into a single unit.
RE: What are the advantages of sql server 2005 over sq...
sql server 2005 is exclusively designed for dot net developers. what ever the function or procedure that we write in dot net environment those function or procedure that we direcly exucute in sql server environment. this is the new feature in sql 2005.
RE: What are the advantages of sql server 2005 over sql server 2000/ sql server 7.0 ?
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 filegroups 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