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.

how to select a field with firstletter as capital and remaining are small letters

11 Answers  

---

How can I track the changes or identify the latest insert-update-delete from a table?

0 Answers  

---

Explain the difference between primary keys and foreign keys?

0 Answers  

---

What is outer join in sql server joins?

0 Answers  

---

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

---

---

What is an Index?

3 Answers   Yardi Software,

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  

---

why SQL server is more used to store database rather than Access

2 Answers  

---

What is intellisense?

0 Answers  

---

What is the difference between ddl,dml and dcl commands?

0 Answers   BirlaSoft, Verifone,

---

Why we need a group by clause?

4 Answers  

---

What is query optimizer in sql server?

0 Answers  

---