GeekInterview.com
Series: Subject:
Question: 71 of 80

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

Asked by: Interview Candidate | Asked on: Jan 22nd, 2007
Showing Answers 1 - 3 of 3 Answers
siva

Answered On : 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.

  
Login to rate this answer.
chandrasekhar

Answered On : 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.

Yes  1 User has rated as useful.
  
Login to rate this answer.
gvs

Answered On : Jan 3rd, 2008

View all answers by gvs

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

Yes  2 Users have rated as useful.
  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.