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 key attribute?
How to create Clustered Primary Key to table?
When multiple after triggers are attached to sql table, how to control the order of execution?
How to use user defined functions in expressions?
How to encrypt Strored Procedure in SQL SERVER?
Describe how to use linked server?
Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation
What is query processing?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
How can you tell if a database object is invalid?
How to update multiple rows with one update statement in ms sql server?
hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju