Answer / debasish

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

there is no sqlserver2002 hope so

Answer / hari

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

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.

Does a server store data?

0 Answers  

---

In which situation you use Self joins?

1 Answers   CarrizalSoft Technologies, HP, TCS,

---

What does it mean to manipulate data?

0 Answers  

---

What is a trigger?

7 Answers  

---

What is a partitioned view?

0 Answers  

---

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

0 Answers  

---

Can primary key be a foreign key?

0 Answers  

---

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

0 Answers  

---

What is a data collection table?

0 Answers  

---

how can u get last observation in an unknown dataset ?

0 Answers   Genpact,

---

Can you explain different types of locks in sql server?

0 Answers  

---

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

4 Answers  

---