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 select an exiting database using mssql_select_db()?

0 Answers  

---

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

0 Answers  

---

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

0 Answers  

---

What is the sql server 2000 version number?

0 Answers  

---

What is view in sql?

0 Answers  

---

Can we passed multiple recordset(set of records) using a Stored Procedure

2 Answers  

---

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

0 Answers  

---

Is sql server is free?

0 Answers  

---

What is measure group, measure? : sql server analysis services, ssas

0 Answers  

---

What are the advantages of stored procedure in sql server?

0 Answers  

---

What is the difference between DATETIME2 and DATETIME?

0 Answers   Infosys,

---

Mention the 3 ways to get a count of the number of records in a table.

0 Answers  

---