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 is joins please explain breffly ??

1 Answers   Adaequare, TCS,

---

What is transact-sql ddl trigger?

0 Answers  

---

Do you know the different ddl commands in sql?

0 Answers  

---

Why does sql studio use a single registered database repository? : sql server management studio

0 Answers  

---

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  

---

---

What is the purpose of linked server configuration in sql server?

0 Answers  

---

How to list all stored procedures in the current database using ms sql server?

0 Answers  

---

What are the different types of triggers in SQL SERVER?

0 Answers  

---

What is bit datatype and what's the information that can be stored inside a bit column?

1 Answers  

---

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

0 Answers   Verizon,

---

What is acid properties?

0 Answers  

---

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

0 Answers  

---