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 a Linked Server?

1 Answers  

---

what is the difference between count(*) and count(1) ?

0 Answers   MCN Solutions,

---

Write a SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,

---

List some case manipulation functions in sql?

0 Answers  

---

Does full backup break log chain?

0 Answers  

---

What is #temp and @table variable in SQL server?

0 Answers  

---

wat wil hapn if we give the both read and deny read permission to user?

0 Answers   IBM,

---

What is a benefit of using an after insert trigger over using a before insert trigger?

0 Answers  

---

Why use triggers?

0 Answers  

---

which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help

3 Answers  

---

What are the functions in sql server?

0 Answers  

---

What is Cross Join and in which scenario do we use Cross Join?

0 Answers   QuestPond,

---