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

how to connect sybase to sql server 2005?.

1 Answers   ABC,

---

Do you know clustered and non-clustered index?

0 Answers  

---

what is Archive old data?

1 Answers  

---

what is sql injection in sql server?

2 Answers   TATA,

---

What is database mirroring?

0 Answers  

---

What is the purpose of forms?

0 Answers  

---

What is normalization 1nf 2nf 3nf?

0 Answers  

---

How will you monitor replication latency in transactional replication? : sql server replication

0 Answers  

---

What is for xml in sql server?

0 Answers  

---

Is sql server difficult to learn?

0 Answers  

---

What is sql sandbox in sql server?

0 Answers  

---

Can we drop user if user mapped to any logins

1 Answers  

---