Follow Our FB Page << CircleMedia.in >> 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 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

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  






Categories