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 do you understand by user-defined function in the sql server?

901

---

What is the use of toad or sqldbx.?

1098

---

what are the types of indexes? : Sql server database administration

1060

---

What is the difference between a primary key and a unique key? Are they the same?

1009

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

856

---

What is difference between primary key and foreign key?

834

---

Define cross join in sql server joins?

964

---

How many servers can we create in a single subscription?

158

---

what is the system function to get the current user's user id? : Sql server database administration

953

---

What is #temp and @table variable in SQL server?

1025

---

what are constraints? Explain different types of constraints? : Sql server database administration

918

---

Define inner join? Explain with an example?

924

---

Do you know what is openxml in sql server?

1015

---

What is the advantage of sql server?

987

---

What happens if you insert a duplicate key for the primary key column in ms sql server?

933

---