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.

How do I open a .db file?

1080

---

When to use Inner join & when to use subquery?

1237

---

What is triggers and its types?

1066

---

Explain syntax for disabling triggers?

1094

---

What is a partition key?

1030

---

What is the purpose of grouping data in a report?

1013

---

Explain what are the restrictions while creating batches in sql server?

1114

---

What is page-level compression?

1009

---

What is the difference between the application object and session object?

1121

---

last function used in MS Access to convert sql what function will use in sql

2114

---

How can we call UDF(User Define Function) using C# code in ASP.net ?

6947

---

What are the steps you will take to improve the performance of a poor performing query?

1019

---

What are types of subqueries?

1132

---

Explain the functionalities that views support?

1162

---

How do you know if sql server is running on your local system?

1095

---