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

What is explicit cursors?

0 Answers  

---

Differentiate between ms sql server reporting services vs crystal reports?

0 Answers  

---

why we use cursor?

4 Answers   CarrizalSoft Technologies, Melstar, TCS,

---

How can you start sql server in different modes?

0 Answers  

---

What does indexation mean?

0 Answers  

---

---

what is hash table

3 Answers   ILFS, Teledata,

---

What is a covering index?

0 Answers  

---

Why would you use sql agent?

0 Answers  

---

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

0 Answers  

---

What are the different ways you can create databases in sql server?

0 Answers  

---

What is data mart? : sql server analysis services, ssas

0 Answers  

---

What is the difference between substr and charindex in the sql server?

0 Answers  

---