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 |
What are character string data types in ms sql server?
How to use clusters?
Can you name some of the dml commands in sql?
How do we return a record set from a Stored Procedure in SQl server 2000?
How to delete a login name in ms sql server?
How to convert a table data in XML format in sql server?
Explain in brief about Microsoft SQL server?
What is data source in connection string?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Explain DBMS, RDBMS?
What is subquery? Explain the properties of a subquery?
How you can get a list of all the table constraints in a database?