plz tell me the new features of
sqlserver2000,sqlserver2002,sqlserver2005
- 3 Answers
- 4792 Views
- I also Faced
- E-Mail Answers
Answer Posted / karthik
sql server 2000 sql
server 2005
Query Analyzer and Enterprise manager Both
combined were Management Studio
are separate
XML data type is not used New
data type XML services is used
we can create only 16 instance we are
able to create 50 instances
clustering or log shipping require enterprise
Clustering,Database mirroing,Logshipping is standard edition
edition(Hardware Expensive) Database
mirroing can use cheap hardware
DTS packages SSIS
Packages
Standard stored procedure It is
modified into CLR stored procedure
Scalability:Limited to 2GB, 4CPUs in
Scalability 4 CPU, no RAM limit in Standard Edition.
More 64-
bit options offer chances for consolidation.
Standard Edition.Limited 64-bit support.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How are the unique and primary key constraints different?
Tell me the difference between clustered and non-clustered index?
What is SQL Azure?
What are parameterized reports?
Explain what are the restrictions while creating batches in sql server?
What is it unwise to create wide clustered index keys?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
Is it possible to replicate data from sql server to oracle? : sql server replication
what is the sql equivaent of the dataset relation object ?
Can we deploy SSRS reports on our personal website?
What is indexing and its types?
What are the database objects? : SQL Server Architecture
What is a performance monitor?
how many triggers you can have on a table? : Sql server database administration
Explain different types of Normalization.
