Answer / 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

How to assign null values to variables or columns?

0 Answers  

---

how can you move the master database

1 Answers   IBM,

---

How many columns can we include on clustered index ?

0 Answers  

---

Why is normalisation important?

0 Answers  

---

What is the full meaning of dml?

0 Answers  

---

In the primary key have a multiple field or not?

8 Answers   TCS,

---

What purpose does the model database server?

0 Answers  

---

Is sql server difficult to learn?

0 Answers  

---

what is sql injection in sql server?

2 Answers   TATA,

---

What is the difference between dbcc indexdefrag and dbcc reindex?

0 Answers  

---

How cand Optimize SQL Server Stored Procedures

1 Answers  

---

What is the use of MOVE keyword in restore command

3 Answers   IBM,

---