Answer Posted / rajkumar

1.SQL Server 2005 has better tool enhancements like SQL
Server Management Studio.
2.Developers can write Native .NET Stored Procedures and
deploy them to SQL Server 2005.
3.It has more Enhancements in the areas of DBA, Developer
Productivity with .NET

For More details..Verify these links..
http://wiki.answers.com/Q/Diff_between_sql_server_2000_and_s
ql_server_2005
http://techinterviewquestion.blogspot.com/2008/06/some-
difference-between-sql-server-2000.html

Explain what are commit and rollback in sql?

874

---

What is the difference between functions and scalar functions?

1139

---

What is correlated subquery in sql server?

1028

---

How to remove duplicate rows from table except one?

956

---

Differentiate between a having clause and a where clause.

930

---

What are types of scd? : sql server analysis services, ssas

985

---

What is an execution plan?

1074

---

You want to implement the one-to-one relationship while designing tables. How would you do it?

926

---

What is a DBMS, query, SQL?

1009

---

How can i Relate Tables in SSIS

1048

---

What happens when converting big values to numeric data types?

1053

---

Tell me the phases a transaction has to undergo?

927

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1000

---

What is a trace frag?

1040

---

What is wrong with sql server client libarary dll, ntwdblib.dll?

1007

---