What are the advantages of sql server 2005 over sql server 2000/ sql server 7.0 ?

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.

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.

  1 User has rated as useful.

  

Login to rate this answer.

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

  2 Users have rated as useful.

  

Login to rate this answer.