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.

Explain the commands in sql server?

0 Answers  

---

Why we use trigger in sql server with example?

0 Answers  

---

Can a function call a stored procedure in sql server?

0 Answers  

---

What do you mean by an execution plan?

0 Answers  

---

System requirements for sql server 2005 express edition?

0 Answers  

---

---

How to work on DTS?what is the main requirement?

1 Answers   Getit, ivan,

---

What are different types of table joins?

0 Answers  

---

How to write a query with a right outer join in ms sql server?

0 Answers  

---

What do you understand by recursive stored procedures?

0 Answers  

---

What are page splits?

0 Answers  

---

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

0 Answers  

---

optimization techinques

0 Answers   Wipro,

---