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 |
difference between truncate, delete aur drop?
What is the osql utility?
How to connect php with different port numbers?
i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...
What is the difference between char and varchar2 datatype in sql?
What is the security principal at the server level that represents your session?
What is the difference between dbcc indexdefrag and dbcc reindex?
How many types of triggers in sql server?
how to trace the traffic hitting a sql server? : Sql server database administration
Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY
Can we use trigger new in before insert?
Name 3 ways to get an accurate count of the number of records in a table?