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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / samplestudy


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

What is Full Outer Join?

3 Answers  

Can store procedure call by user define function in SQL server?

10 Answers   HCL,

Explain the different types of joins?

0 Answers  

What is instead of dml trigger?

0 Answers  

What is store procedure? How do they work? When do you use?

0 Answers  

how to find nth highest salary

103 Answers   Cognizant, IBM, NexGen, Oracle,

Describe the functionalities that views support.

0 Answers  

last function used in MS Access to convert sql what function will use in sql

0 Answers   Cap Gemini,

What is dml command?

0 Answers  

Why would you use sql agent?

0 Answers  

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

11 Answers   World Tech, Yardi Software,

What is an indice?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories