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 deploy, process and build? : sql server analysis services, ssas

579


What is the openxml statement in sql server?

543


How to create a new schema in a database?

561


What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

609


What are the different Authentication modes in SQL Server and how can you change authentication mode?

650






What is the default server name for sql server?

649


What is the advantage of sql server?

550


When to use null data driven subscription?

149


What is the latest version of microsoft sql server?

490


Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

549


Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

599


Who developed sql server?

538


What is create command?

531


What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

706


How to see the event list of an existing trigger using sys.trigger_events?

575