1.Resource Databases
2.Security enhancement
3.Dynamic Management Views
4.Mirroring
5.Database Snapshots
6.Online Restore
7.On line-Rebuild Index by using snapshot Isolation
8.Tbldiff utility
9.Replication:allow supscriber Updates,introduced Tracer Token to get know the latency
10.SSIS packages
11.Data encryption and compression
12.High scalability:Limited to 2GB, 4CPUs in Standard Edition. Limited 64-bit support for SQl 2000 but in Sq 2005 we can use 4 CPU, no RAM limit in Standard Edition. More 64-bit options offer chances for consolidation.
13.SQL server managaement Studio tool.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment