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 function does a database engine serve in the sql server?

1 Answers  

---

what are database files and filegroups? : Sql server database administration

1 Answers  

---

Explain the disadvantages/limitation of the cursor?

1 Answers  

---

What do you mean by subquery?

1 Answers  

---

How to define output parameters in stored procedures?

1 Answers  

---

What is Data model and how to prepare a data model.?

1 Answers   TCS,

---

Can we update data in a view?

1 Answers  

---

What is triggers and its types?

1 Answers  

---

Please illustrate physical database architecture? : SQL Server Architecture

1 Answers  

---

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1 Answers  

---

How are the exceptions handled in sql server programming?

1 Answers  

---

How can we get count of the number of records in a table?

1 Answers  

---