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

How to delete existing rows in a table?

1181

---

Why do we use stored procedures in sql server?

958

---

What is the difference between a unique key and primary key?

969

---

How to recover from sql injection? : sql server security

1030

---

What is table value parameters (tvp)?

1113

---

What is blocking and how would you troubleshoot it? : sql server database administration

1061

---

What are information schema views?

998

---

Describe how to use linked server?

1032

---

Why do you need a sql server?

1120

---

What is a hint?

1008

---

Differentiate between truncate vs delete in mssql?

1098

---

What are the different types of backups that exist?

1187

---

can a table be moved to different filegroup? : Sql server administration

990

---

How do I determine how many instances of sql server are installed on a computer?

1015

---

What is model database? : SQL Server Architecture

1145

---