Answer / Saket Shukla

Indexes can have several disadvantages: 1) They take up additional storage space. 2) They require more time to create, maintain, and update. 3) They can lead to slower data modification operations because changes need to be reflected in the index as well as the actual table data. 4) If not properly designed, they can result in poor performance due to issues such as wide keys or high fill factors.

how to control the amount of free space in your index pages? : Sql server database administration

1 Answers  

---

Difeerence between ssis 2005 and ssis2008?

1 Answers   Convergys,

---

What is stored in the mssqlsystemresource database? : sql server database administration

1 Answers  

---

How do I delete a sql server database?

1 Answers  

---

What are the different types of lock modes in sql server 2000?

1 Answers  

---

What gets stored inside msdb database?

1 Answers   Abacus,

---

What is intellisense?

1 Answers  

---

How to trouble shoot if unable to connect SQL Server

1 Answers  

---

Can you explain what is indexed view? How to create it?

1 Answers  

---

Differentiate between mongodb vs. Sql server?

1 Answers  

---

What are statistics?

1 Answers  

---

can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3

15 Answers   Google,

---