what are the new features of sql server 2005?
- 8 Answers
- 11417 Views
- HP, Keane India Ltd, I also Faced
- E-Mail Answers
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
In what three ways is the return statement used in a stored procedure?
What is a cube? : sql server analysis services, ssas
what is database replication? : Sql server database administration
What are functions in the sql server?
How are the unique and primary key constraints different?
Explain what are the basic functions for master, msdb, model, tempdb databases?
What is dbcc?
Explain what are commit and rollback in sql?
What is molap and its advantage? : sql server analysis services, ssas
How to replace given values with null using nullif()?
please differentiate between delete and truncate?
what is denormalization and when would you go for it? : Sql server database administration
Do you know nested transaction?
What is a functions and types in sql server?
How to Sync Two SQL Azure Databases?
