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.

Explain features and concepts of analysis services?

578

---

Do you know what are the ways available in sql server to execute sql statements?

628

---

How to change server name in sql server?

675

---

How do I create a stored procedure in dbml?

606

---

What is cursors?

721

---

---

Give main differences between "Truncate" and "Delete".

671

---

How to find table changes in sql server?

754

---

Is the log file is a part of file group?

637

---

What is attribute hierarchy? : sql server analysis services, ssas

610

---

What are the different types of data sources in ssrs?

155

---

What is the difference between dbcc indexdefrag and dbcc reindex?

613

---

What is attribute? : sql server analysis services, ssas

674

---

Explain for xml explicit mode?

654

---

What is data source in connection string?

560

---

What is the use of nvl work?

655

---