Answer / Hari Shanker Vishwakarma

Creating wide Clustered Index Keys can lead to poor performance because it increases the size of each data page, which in turn increases the likelihood of page splits and reduces the number of rows that can fit on a single page. This can lead to increased I/O operations, slower reads, and slower insert, update, and delete operations.

What is MSDE?

2 Answers  

---

What is the sql server agent?

1 Answers  

---

How you can get a list of all the table constraints in a database?

1 Answers  

---

How to delete a database in ms sql server?

1 Answers  

---

What happens if an integer is too big for int date type?

1 Answers  

---

Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?

3 Answers   Apple,

---

What is PROJECTION Operation?

1 Answers   Infosys,

---

What happens if null values are involved in boolean operations?

1 Answers  

---

Give a example to search fr a string in all stored procedure in sql server.

1 Answers  

---

How many types of TRIGGERS are there in MS SQL Server?

8 Answers   CarrizalSoft Technologies, TCS, United Healthcare,

---

What is the order by used for?

1 Answers  

---

How to receive output values from stored procedures?

1 Answers  

---