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 are the different Topologies in which Replication can be configured?

0 Answers  

---

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

0 Answers  

---

What are the different types of locks in the database?

0 Answers  

---

What is primary key and example?

0 Answers  

---

What's new in sql management studio for sql server? : sql server management studio

0 Answers  

---

---

How you would rewrite the sql query to return the customerid sorted numerically?

0 Answers  

---

What is temporary table in sql server? Why we use temp table?

0 Answers  

---

What is deploy, process and build? : sql server analysis services, ssas

0 Answers  

---

What is sql server programming?

0 Answers  

---

What is fill factor and pad index?

0 Answers  

---

What are the advantages of sql stored procedure?

0 Answers  

---

Can we delete data from a view?

0 Answers  

---