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

What is rtm version in sql server?

1055

---

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1111

---

Can I delete event logs?

924

---

How do I start sql server 2016?

911

---

How do I manually uninstall an instance of sql server 2016?

1038

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1049

---

What is the impact on other user sessions when creating indexes?

927

---

What is sql server replication? : sql server replication

992

---

What is the return type of executeupdate ()?

907

---

What is the sql server agent?

1091

---

When do you think a developer should use sql server-based cursors?

1048

---

How do I clean up sql server transaction log?

1068

---

Which tools are available to manage SQL Azure databases and servers?

115

---

How do I run sql server 2014?

1003

---

What options are available to audit login activity? : sql server security

1153

---