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

what is blocking? : Sql server database administration

729


What is the index requirement in SQL Azure?

86


Why do we use trigger?

714


Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

786


How to enable tcp/ip protocol on a sql server?

796


What is subreport?

112


what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

711


How do I view views in sql server?

700


Do you know what is a with(nolock)?

800


What are the recovery models for a database?

817


Explain primary key and foreign key constraints?

714


What is the user of Primary key?

746


Can sql server be linked with other servers like oracle?

707


Explain rdbms?

755


What are the advantages of log shipping?

738