Interested to Buy Any Domain ? << Click Here >> for more details...
What are the limitation of the Online Index Rebuild Operation?
- 1 Answers
- 3748 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the sql server 2000 version number?
How to create a new schema in a database?
Mention what are the different types of ssrs reports?
Is it safe to delete log files?
How to receive output values from stored procedures?
What is cross join in sql server joins?
How to connect a database with sql express.?
What is a join in sql?
What is extent? Types of extents?
How to provide default values to function parameters?
wat wil hapn if we give the both read and deny read permission to user?
How many types of triggers are there?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
where can you add custom error messages to sql server? : Sql server administration
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
