Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

What is mean by "fill factor" ? and what is mean
by "Index "in sql?

What is mean by "fill factor" ? and what is mean by "Index "in sql?..

Answer / 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 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

More SQL Server Interview Questions

Can we store videos inside the sql server table?

0 Answers  

What is ddl command?

0 Answers  

How to create a simple user defined function in ms sql server?

0 Answers  

What is isnull() operator?

0 Answers  

You want to implement the one-to-one relationship while designing tables. How would you do it?

0 Answers  

What is database white box testing?

0 Answers  

how to get max salary with employee number by using one select query and max function ??

3 Answers   Genpact,

how can we use a composite key for two tables and how can we represent it

1 Answers   BoA,

Are resultset updatable?

0 Answers  

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers  

syntax and example for bitmap index in sql???

1 Answers  

When cursors are useful?

0 Answers