Answer / Shailendra Sharma

Fill Factor in SQL Server is a property that determines the percentage of space occupied by data within a page. By setting a non-default Fill Factor value, you can leave empty space within pages for indexes and tables to allow for insertions and updates without requiring reorganization or fragmentation.

What is the difference between migration and upgradation in sql server?

1 Answers  

---

How optimize sql query with multiple joins in sql server?

1 Answers  

---

What are the differences between clustered and non-clustered index?

1 Answers  

---

How many types of Joins in SQL Server 2005?

9 Answers   CarrizalSoft Technologies, HCL,

---

What happens if you are trying to access a schema not owned by you?

1 Answers  

---

How to create a dml trigger using create trigger statements?

1 Answers  

---

what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,

---

What command would you use to add a column to a table in sql server?

1 Answers  

---

What are the different types of locks in the database?

1 Answers  

---

How to delete duplicate rows in sql server?

1 Answers  

---

What is the difference between char and varchar2 datatype in sql?

1 Answers  

---

Alternative way to DetDate() function?

5 Answers  

---