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.

Mention the different types of triggers?

1114

---

What are various ways to enhance the ssrs report?

981

---

What is the usage of sign function?

1109

---

Define cross join in sql server joins?

1021

---

Can you tell me about the concept of ER diagrams?

1067

---

How does using a separate hard drive for several database objects improves performance right away?

932

---

Explain Geography datatype in SQL Server

1127

---

In which format does an image save in SQL Server database ?

1001

---

Explain subquery and state its properties?

1042

---

What is sql sandbox in sql server?

1222

---

What is sql service broker?

982

---

What is sharding?

116

---

Why use view instead of a table?

953

---

What are locks in sql?

978

---

What is merge statement?

1080

---