Answer / Shashwat Gupta

A lower fill factor is used when you want to reduce contention for page allocation, allowing new pages to be inserted more quickly. It's also useful when data grows unevenly or when the table will have frequent bulk inserts. However, a lower fill factor increases the overhead of maintaining the database and can lead to more fragmentation.

What is user defined datatypes and when you should go for them?

1 Answers  

---

What is a trigger? Why we need it?

1 Answers   Accenture,

---

What is a Trace frag?Where can we use this?

1 Answers  

---

How does recursive cte works in sql server?

1 Answers  

---

how many clustered indexes can be created on a table? : Sql server database administration

1 Answers  

---

What are xml indexes?

1 Answers  

---

How to transfer data from a cursor to variables with a "fetch" statement?

1 Answers  

---

How to find which stored procedure is currently running in sql server?

1 Answers  

---

How do I make a resultset scrollable?

1 Answers  

---

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

2 Answers  

---

Determine when to use stored procedure to complete sql server tasks?

1 Answers  

---

What factors you will consider calculating the storage requirement for that view?

1 Answers  

---