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

How to query multiple tables jointly?

1042


Explain how you can deploy an SSRS report?

156


Can you explain different types of joins?

986


What is sql profiler. What are the default templates with it? : sql server database administration

1106


Can you tell me some of the common replication dmv's and their use? : sql server replication

975


What is xml datatype?

1129


How to send email from database?

1071


What are the reporting services components?

144


Explain the Ways to improve the performance of a sql azure database?

84


How can you append an identity column to a temporary table?

1031


How to replace the Query Result 'Null Value' with a text ?

1094


Comment,Datatypes are unlimited

2106


How to test odbc dsn connection settings?

1086


how many no of arguments can be passed in procedures and functions

5641


Difference between 2NF &3NF ?

1132