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.

What are various aggregate functions that are available?

0 Answers  

---

what is a transaction and what are acid properties? : Sql server database administration

0 Answers  

---

What is the difference between drop table and truncate table?

0 Answers  

---

please tell me the query to get details of the employee having the second largest salary

11 Answers   247Customer,

---

What are the types of indexes?

0 Answers  

---

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

0 Answers  

---

Explain what is the use of custom fields in report?

0 Answers  

---

What is a Join in SQL Server?

3 Answers  

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

0 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

which backup strategy you are following at ur company

0 Answers  

---

Why union all is faster than union?

0 Answers  

---