Answer Posted / saravakumar

As title is very clear what this post is about I will not
write long description. I have listed definition of
FILLFACTOR from BOL here.
FILLFACTOR
Specifies a percentage that indicates how full the Database
Engine should make the leaf level of each index page during
index creation or alteration. fillfactor must be an integer
value from 1 to 100. The default is 0.
T-SQL Script to set Server level FILLFACTOR to 90
EXEC sys.sp_configure 'show advanced options', '1'
RECONFIGURE WITH OVERRIDE
GO
EXEC sys.sp_configure 'fill factor (%)', '90'
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sys.sp_configure 'show advanced options', '0'
RECONFIGURE WITH OVERRIDE
GO

What are click through reports?

142

---

How do indexes help, types?

938

---

How to populate a table in sql server?

942

---

What is the difference between count and distinct count?

872

---

Is ssrs support other database except ms sql server?

139

---

how you can list all the tables in a database?

1013

---

What are key constraints?

960

---

What is self join in sql server joins?

1031

---

What is order of B+tree?

1095

---

What is cursors?

1158

---

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2058

---

What is an identity?

982

---

How do I schedule a sql server profiler trace?

967

---

Can a database be shrunk with users active?

1112

---

Detail about query optimizer?

1079

---