Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


plz tell me the new features of
sqlserver2000,sqlserver2002,sqlserver2005

Answers were Sorted based on User's Feedback



plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005..

Answer / debasish

in 2005--database mirroring,CLR Integarion,SIS,Data
paratition, xml datatype,Dynamic management views,Mirror
backup

there is no sqlserver2002 hope so

Is This Answer Correct ?    3 Yes 0 No

plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005..

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

plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005..

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

Post New Answer

More SQL Server Interview Questions

Does transparent data encryption provide encryption when transmitting data across the network?

0 Answers  


What is nolock hint in sql server 2008

0 Answers   HCL,


Explain triggers in sql?

0 Answers  


What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,


What is the difference between a function and a trigger?

0 Answers  


Can we insert data if clustered index is disabled?

0 Answers  


please tell me the query to get details of the employee having the second largest salary

11 Answers   247Customer,


what operator performs pattern matching?

2 Answers  


what is the Enterprise manager(2000) and management studio (2005)?

2 Answers  


How to create a local temporary stored procedure?

0 Answers  


Explain atomicity?

0 Answers  


What is the difference between varchar and nvarchar datatypes?

0 Answers  


Categories