Answer Posted / 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.

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

941

---

What is 1nf normalization form?

987

---

Can a synonym name of a table be used instead of a table name in a select statement?

988

---

What is a performance monitor?

933

---

What is BLOCK statements in SQL?

1223

---

What are approximate numeric data types in ms sql server?

1022

---

How to store and query spatial data?

953

---

What is clr ddl trigger?

923

---

What is cross join in sql server joins?

1087

---

Define self join?

996

---

What is the recursive stored procedure in sql server?

982

---

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1710

---

What is row-level compre?

961

---

What are Row versions of DataRow?

989

---

Can you type more than one query in the query editor screen at the same time?

965

---