Tell me what are the new features in SQL Server 2005 when compared to SQL Server 2000?
Submitted by: MuhammadThere are quite a lot of changes and enhancements in SQL Server 2005. Few of them are listed here:
☛ Database Partitioning
☛ Dynamic Management Views
☛ System Catalog Views
☛ Resource Database
☛ Database Snapshots
☛ SQL Server Integration Services
☛ Support for Analysis Services on a Failover Cluster.
1.Profiler being able to trace the MDX queries of the Analysis Server.
2.Peer-toPeer Replication
3.Database Mirroring
Submitted by: Muhammad
☛ Database Partitioning
☛ Dynamic Management Views
☛ System Catalog Views
☛ Resource Database
☛ Database Snapshots
☛ SQL Server Integration Services
☛ Support for Analysis Services on a Failover Cluster.
1.Profiler being able to trace the MDX queries of the Analysis Server.
2.Peer-toPeer Replication
3.Database Mirroring
Submitted by: Muhammad
Read Online SQL Administrator Job Interview Questions And Answers
Top SQL Administrator Questions
| ☺ | Tell me why would you use SQL Agent? |
| ☺ | Please explain why would you call Update Statistics? |
| ☺ | How to start SQL Server in different modes? |
| ☺ | Tell me what is SQL Server VSS Writer? |
| ☺ | Do you know what is SQL Server service and its importance? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
| ☺ | Sybase Interview Questions. |
