Interested to Buy Any Domain ? << Click Here >> for more details...
What is mean by "fill factor" ? and what is mean
by "Index "in sql?
- 1 Answers
- 9257 Views
- iGate, Logica CMG, I also Faced
- E-Mail Answers
Answer Posted / gunjan sapra
fill factor is a defiened percentage between 0 to 100 in
which we leave exra gaps to accomodate future expansions in
the storage of the futures data.
indexing in sql is same as the index in our books. it helps
us to manage our data more appropriately.it can be done in
two ways namely clustered index and non-clusterd index.
we can create only one clustered index per table and
maximum of 249 non-clustered indexes per table.
| Is This Answer Correct ? | 15 Yes | 6 No |
Post New Answer View All Answers
What command is used to create a database in the sql server and how?
Why the trigger fires multiple times in single login?
what are different types of raid configurations? : Sql server database administration
You are doing log shipping due to some reasons it is failing. How you will proceed from there
What is implicit mode in sql server?
How many primary keys are possible in a table?
How to assign null values to variables or columns?
What is a full text index?
Does a full backup include transaction log?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What is it unwise to create wide clustered index keys?
Why transaction is important?
What is a unique key constraint?
Tell me the difference between clustered and non-clustered index?
