Answer Posted / arun pandey

There are the New Feature

1)online indexing only in sql 2005.
2)CLR Integration with sql server 2005.
3)xml datatype in sql 2005.
4)More faster than sql 2000.
5)Inbuilt with ASP.NET 2005.

What is the function of sql server agent windows service?

1099

---

What does ss stand for sexually?

1089

---

What are the restrictions that views have to follow? : SQL Server Architecture

1003

---

What is the difference between ‘having’ clause and a ‘where’ clause?

1041

---

Difference between connected and disconnected database in .net with sql server?

1103

---

What is the difference between online clustering and Offline clustering?

2419

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1150

---

What are the aggregate and scalar functions?

1070

---

What is the difference between push and pull subscription? : sql server replication

1219

---

Is there any difference between primary key and unique with the not null condition?

953

---

Where is my database stored on the hard disk in ms sql server?

1063

---

How to update muliple row in single query?

1062

---

What is self contained sub query?

1063

---

Can we add a cpu to sql server?

1018

---

What is the user of Primary key?

990

---