Answer Posted / kokkula raju

More powerful management
Policy Management feature
Improved performance and scalability
Storing high volume of data
Support for diverse types of data
Better security and availability
Security increased by data encryption
Availability increased by database mirroring
Changes for developers

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1020

---

What are database states in ms sql server?

1160

---

What can be used instead of trigger?

1128

---

Suggest a method of joining two tables.

1142

---

How many levels of sp nesting are possible?

991

---

What is difference between delete & truncate commands?

1060

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

930

---

Is t sql the same as sql server?

945

---

Explain what is it unwise to create wide clustered index keys?

965

---

What is difference in performance between insert top (n) into table and using top with insert?

1019

---

What is data compression?

972

---

What stored by the master? : sql server database administration

1083

---

Can a table have 2 primary keys?

967

---

what is the sql equivaent of the dataset relation object ?

1997

---

Mention a few common trace flags used with sql server?

915

---