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
What is difference between index seek vs. Index scan?
What is the beast way to write CTE in SQL Server ?
Explain what is log shipping?
What is data mart? : sql server analysis services, ssas
What is table level trigger?
what are database files and filegroups? : Sql server database administration
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What is a linked server in sql server?
What is primary key, unique key, and foreign key?
Tell me what is a linked server?
How do you check sql server is up and running?
How to find the list of fixed hard drive and free space on server?
Explain powershell included in sql server 2008?
What is an sql server agent?
how would you troubleshoot blocking? : Sql server database administration