Answer / Vibhut Narayan Pandey

Creating wide clustered index keys (keys with many columns) can be inefficient because SQL Server stores the entire table in the index due to the key's size. This increases the storage space required, decreases performance, and slows down insert, update, and delete operations.

explain different types of constraints? : Sql server database administration

1 Answers  

---

What is Inner Join?

2 Answers  

---

What are the events recorded in a transaction log?

1 Answers  

---

How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

1 Answers  

---

Tell me what are the advantages of using stored procedures?

1 Answers  

---

What are the different types of triggers in SQL SERVER?

1 Answers  

---

What are the four main query statements?

7 Answers   Wipro,

---

What is nolock hint in sql server 2008

1 Answers   HCL,

---

can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 Answers  

---

What is it unwise to create wide clustered index keys?

1 Answers  

---

Can a rule be bound to any column of any data type?

1 Answers  

---

How to create a simple table to test triggers in ms sql server?

1 Answers  

---