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
How does stuff differ from the replace function?
Can you pass expressions to stored procedure parameters?
What is the difference between char, varchar and nvarchar?
What do you mean by the term 'normalization'?
What is executereader?
How to create a simple stored procedure in ms sql server?
How to filter out duplications in the returning rows in ms sql server?
Explain mixed authentication mode of sql server?
How to change server name in sql server?
What is reportserver and reportservertempdb ?
What factors you will consider calculating the storage requirement for that view?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
Do you know what are the reporting services components?
how can you attach more than 20 ldf files in sql server
what are the reporting service components in SSRS?