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.

What do you mean by an execution plan? Why is it used?

528

---

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

554

---

Can we deploy SSRS reports on our personal website?

123

---

How to get the definition of a view out of the sql server?

502

---

How to remove duplicate rows from table except one?

567

---

---

how would you improve etl (extract, transform, load) throughput?

540

---

What is an example of a foreign key?

507

---

How would you choose between a clustered and a non-clustered index?

543

---

What is autocommit mode in sql server?

541

---

What is sub-query in sql server? Explain its properties.

574

---

Is ssrs support other database except ms sql server?

96

---

What is compression - row-level and page-level compression?

528

---

Explain can you implement data mining in ssrs?

106

---

How can we check the sql server version?

558

---

How to link tables in sql server?

473

---