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

Is it possible to have clustered index on separate drive from original table location?

1041

---

How do I find query history in sql server?

1025

---

What are the different SQL Server Versions you have worked on?

1080

---

do you know how to configure db2 side of the application? : Sql server database administration

1125

---

What are the different subsets of sql?

1654

---

What is self contained sub query?

1141

---

Can one drop a column from a table?

1091

---

Explain “row_number()” in sql server with an example?

1080

---

Can we shrink data file in sql server?

1130

---

What is clustered index

1087

---

Where can you add custom error messages to sql server?

1215

---

What is sql or structured query language?

1228

---

What is the difference between for xml raw and for xml auto?

1119

---

How can you append an identity column to a temporary table?

1071

---

What is subquery? Explain the properties of a subquery?

1063

---