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 does stuff differ from the replace function?

738


Can you pass expressions to stored procedure parameters?

710


What is the difference between char, varchar and nvarchar?

762


What do you mean by the term 'normalization'?

857


What is executereader?

728






How to create a simple stored procedure in ms sql server?

706


How to filter out duplications in the returning rows in ms sql server?

816


Explain mixed authentication mode of sql server?

717


How to change server name in sql server?

797


What is reportserver and reportservertempdb ?

131


What factors you will consider calculating the storage requirement for that view?

710


Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

671


Do you know what are the reporting services components?

712


how can you attach more than 20 ldf files in sql server

1744


what are the reporting service components in SSRS?

139