plz tell me the new features of
sqlserver2000,sqlserver2002,sqlserver2005
Answers were Sorted based on User's Feedback
Answer / hari
in 2005--database mirroring,CLR Integarion,SIS,Data
paratition, xml datatype,Dynamic management views,Mirror
backup
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
What is the difference between implicit and explicit transaction?
How to get a list of columns in a view using the "sp_help" stored procedure?
What are mdf,ndf,ldf files and how to see the data in those files?
What are the types of indexes?
Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?
How many types of Cursor in SQL SERVER?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
Explain about remote stored procedure?
Can you roll back the ddl statement in a trigger?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
If user is owning any SQL Objects, can we drop that user
What is the difference between seek predicate and predicate?