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

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

0 Answers  

---

How do I compare two values when one value(data type) is char and the other is an integer?

3 Answers  

---

What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

3 Answers   TCS,

---

What is meant by Active-Passive and Active-Active clustering setup?

0 Answers  

---

Which one is faster delete/truncate? Why?

1 Answers   Infosys,

---

---

How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

2 Answers   247Customer,

---

Can we use max in where clause?

0 Answers  

---

What is the largest component inside a field?

0 Answers  

---

hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?

7 Answers   Google, TCS, Unisys,

---

What is SubQuery in SQL Server 2008

0 Answers   HCL,

---

What are constraints in microsoft sql server?

0 Answers  

---

How to delete duplicate records based on single column from a table?

0 Answers   Petranics Solutions,

---