what are the new features of sql server 2005?

Answer Posted / dinesh from a1-technology

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.
6)GetDate() function also working in function in 2005 sql.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If any stored procedure is encrypted, then can we see its definition in activity monitor?

561


What are policy management terms?

572


Explain the different types of joins?

577


Can we insert data into view sql server?

521


What is the command to change the recovery model?

572






What are the advantages of user-defined functions over stored procedures in sql server?

470


How to see existing views in ms sql server?

554


What are trace flags and mention a few common trace flags used with sql server?

559


What is function of CUBE ?

614


What is merge statement?

633


Do you know sql server 2008 introduces automatic auditing?

527


tell me the disaster recovery plan

2033


Do you know what is lock escalation?

594


What is a trace frag? Where do we use it?

682


How to delete multiple rows with one delete statement in ms sql server?

525