what are the new features of sql server 2005?

Answer Posted / arun pandey

There are the New Feature

1)online indexing only in sql 2005.
2)CLR Integration with sql server 2005.
3)xml datatype in sql 2005.
4)More faster than sql 2000.
5)Inbuilt with ASP.NET 2005.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

You are doing log shipping due to some reasons it is failing. How you will proceed from there

1545


How many joins in sql server?

516


Write a program to fetch first 10 records from a file?

600


What is named query? : sql server analysis services, ssas

509


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5495






What is cursors?

636


Do you know sql server 2008 backup compression?

564


Which table keeps information about stored procedures?

531


How to provide default values to function parameters?

593


Which are the two editions in which SQL Azure database available?

99


What is normalization according to you and explain its different levels?

522


Do you know what guidelines should be followed to help minimize deadlocks?

534


What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

520


What are parameterized reports?

160


Explain relational data?

543