Answer / 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

Answer / jigar

Row Constructors

Output Clause

Compound Operators

Inline Variable Assignment

Grouping Sets

Explain syntax for viewing trigger?

0 Answers  

---

Explain what are the different index configurations a table can have?

0 Answers  

---

What are the different editions available in sql server 2000?

0 Answers  

---

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

1 Answers  

---

What is the cartesian product of table?

0 Answers  

---

---

What are “unrepeatable reads”?

0 Answers  

---

What is de-normalization and what are some of the examples of it?

0 Answers  

---

How many full-text indexes can a table have?

0 Answers  

---

What is Check point? Explain in Brief what it will do?

1 Answers   Wipro,

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

To which devices can a backup be created and where should these devices be located? : sql server management studio

0 Answers  

---

What is normalization? Describe its different types.

0 Answers   Wipro,

---