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 the new security features added in sql server 2016? : sql server security

0 Answers  

---

WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

1 Answers   Synergy,

---

Plz tell about backup&recovery?

3 Answers  

---

What is BCP? When does it used in sql server 2012?

0 Answers   TryTechnicals Pvt Ltd,

---

What Are Three Rules to Use UNION IN SQL SERVER

1 Answers  

---

What happens when unicode strings concatenate with non-unicode strings?

0 Answers  

---

Determine when to use stored procedure to complete sql server tasks?

0 Answers  

---

what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 Answers  

---

what is normalization? : Sql server database administration

0 Answers  

---

Can coalesce return null?

0 Answers  

---

How to use the inserted and deleted pseudo tables?

0 Answers  

---

Is mysql better than sql server?

0 Answers  

---