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.

do you know how to configure db2 side of the application? : Sql server database administration

1056

---

How to provide values to stored procedure parameters in ms sql server?

1048

---

What is a View ? Can we insert, Update and delete a view?

1007

---

How extra digits are handled with numeric data type literals?

976

---

can a table be moved to different filegroup? : Sql server administration

990

---

List the different index configurations possible for a table?

939

---

What is coalesce in sql server?

1067

---

What do you mean by sql server agent?

1004

---

What is the difference between for trigger and after trigger?

1120

---

What is normalization? Explain different forms of normalization?

1170

---

Explain indexes disadvantages?

1102

---

Can group by and orderby be used together?

1029

---

what is the maximum size of a row? : Sql server database administration

1026

---

Where sql server user names and passwords are stored in sql server? : sql server database administration

1069

---

Can we hide the definition of a stored procedure from a use?

1236

---