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 is view in sql?

0 Answers  

---

Which sql server is best?

0 Answers  

---

What is the diff between Dynamic queries and static queries

1 Answers   CGG, ICS Integrated Computer Solutions,

---

How you can change the database name in SQL SERVER?

0 Answers  

---

Is trigger fired implicitely?

2 Answers  

---

Define synonym?

0 Answers  

---

Which is best Subquery (or) joins in sql server? explain why

2 Answers  

---

Can group functions be mixed with non-group selection fields in ms sql server?

0 Answers  

---

How will u test the stroded procedures and functions? difference between SP and Triggers

2 Answers   TCS,

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

---

What are the differences between left join and inner join in sql server?

0 Answers  

---

CLR Integration ? what is Notification services ?

1 Answers   HCL, Satyam,

---