what are the new features of sql server 2005?

Answer Posted / mruganandam(guru) mca saranath

The some features of sql server 2005 are,

1.Database Mirroring
2.Online Restore
3.Online Indexing Operation
4.Fast Recovery
5.Standards based Information Access
6.Sql Server Information Access
7.Dedicated Administrator Connection
8.Snapshot Isolation(SI)
9.Data Partitioning
10.Replication Enhancements.
which are the top ten features of Database Administration
in Sql Server 2005.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create a Master database in SQL server ?

560


How to deploy the Report?

95


What is the bookmark lookup and rid lookup?

580


Tell me what is difference between clustered and non clustered index?

563


What are diverse clauses that form a part of sql?

609






What is a field name?

525


Write a query for primary key constraint with identity key word?

585


What is scrollable cursor?

549


How to get the definition of a view out of the sql server?

513


How do I find sql server instance name?

516


How to copy data from one table to another table?

553


How to use go command in "sqlcmd"?

652


What is a system database and what is a user database?

590


How to trouble shoot if unable to connect SQL Server

1488


How will you know when statistics on a table are obsolete?

622