Interested to Buy Any Domain ? << Click Here >> for more details...
what are the new features of sql server 2005?
- 8 Answers
- 13220 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
What is partitioned view?
Explain the difference between delete,drop and truncate in SQL Server?
Write the SQL query to drop, truncate and delete table.
What do you mean by collation recursive stored procedure?
Explain “@@rowcount” and “@@error” in sql server?
What is #table in sql server?
What are the hotfixes and patches in sql server?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Differentiate between a local and a global temporary table?
What are “lost updates”?
what is create database syntax? : Sql server database administration
what's the maximum size of a row? : Sql server database administration
How to view the error log for any specific instance? : sql server database administration
What are pages and extents? : SQL Server Architecture
What is the difference between web edition and business edition?
