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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / swapna

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

What is the difference between HAVING clause and the WHERE clause?

7 Answers  

what stored procedure would you use to view lock information? : Sql server administration

0 Answers  

Explain what is lock escalation?

0 Answers  

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

What are the different SQL Server Versions you have worked on?

0 Answers  

How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

9 Answers   TCS,

What is the purpose of the tempdb database?

0 Answers  

write query for fourth maximum salary from employee table

14 Answers   Mind Tree, SP Software,

How to rebuild indexes with alter index ... Rebuild?

0 Answers  

Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60

3 Answers   IT Decisions,

Can you pass expressions to stored procedure parameters?

0 Answers  

How to update muliple row in single query?

0 Answers   MCN Solutions,

For more SQL Server Interview Questions Click Here
Categories