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

Create and insert into temp table in sql server?

1014

---

What is the process of indexing?

999

---

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

936

---

Do you know what are different types of replication in sql server?

1087

---

Name some of the open source software that you can use in alternative to SSR?

159

---

What are the properties of the transactions?

1110

---

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1206

---

Does index slows down insert statements?

991

---

What are the differences between char and nchar in ms sql server?

1076

---

What is user-defined scalar function?

956

---

What stored procedure would you use to view lock information?

961

---

What are the 2 types of classifications of constraints in the sql server?

1111

---

Distinguish between nested subquery and correlated subquery?

1033

---

Difference between group by clause and having clause in SQL?

963

---

Why are sql functions used?

1110

---