Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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


Please Help Members By Posting Answers For Below Questions

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

933


What is lookup override?

989


What is the difference between a check constraint and a rule?

1185


What is a derived table?

893


Explain what is scheduled job and how to create it?

924


Explain view in sql server?

1030


What is compound operators?

1010


How to start and end transact-sql statements?

996


What is sql server 2000 work load governor?

1011


What are data files?

1005


What are the different normalization forms?

1068


What is the difference between a primary key and a unique key? Are they the same?

1036


What are the built in functions in sql server?

946


What is the process of normalising?

973


What is constraints and its types?

902