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|
Can we store videos inside the sql server table?
What is ddl command?
How to create a simple user defined function in ms sql server?
What is isnull() operator?
You want to implement the one-to-one relationship while designing tables. How would you do it?
What is database white box testing?
how to get max salary with employee number by using one select query and max function ??
how can we use a composite key for two tables and how can we represent it
Are resultset updatable?
Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???
syntax and example for bitmap index in sql???
When cursors are useful?