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
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
How does a profiler work?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
Define ACID properties in a Database?
What are the restraints imposed on the table design by a merge replication?
Explain primary key, foreign key and unique key?
What are the underflow and overflow behaviors on float literals?
How to convert a numeric expression from one data type to another?
What are the different types of normalization?
Which language is supported by sql server?
What purpose does the model database server?
In what three ways is the return statement used in a stored procedure?
Can multiple columns be used in sql group by clause in ms sql server?
What is stretch database in sql server?
How to count rows with the count(*) function in ms sql server?