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.

Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply

1 Answers   Covansys,

---

what are batch in sql server?

2 Answers   Satyam,

---

What is the difference between IN and EXISTS operators in SQL Server?

9 Answers   ASD Lab, CSC, Intelligroup,

---

Explain intellisense for query editing

0 Answers  

---

What is delete query?

0 Answers  

---

---

Explain how many types of relationship?

0 Answers  

---

What are different types of subquery?

0 Answers  

---

How will you hide an attribute? : sql server analysis services, ssas

0 Answers  

---

What is the maximum size of column in sql server?

0 Answers  

---

Write the Syntax for Cursors.

2 Answers   CarrizalSoft Technologies, HP,

---

How to use transact-sql statements to access the database engine?

0 Answers  

---

Explain the concept of recursive stored procedure.

0 Answers  

---