siva

• Feb 5th, 2007

 

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.

chandrasekhar

• May 17th, 2007

 

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.

gvs

 Profile Answers by gvs 

• Jan 3rd, 2008

 

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