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 what is the main purpose of having conversation group?

0 Answers  

---

What is the difference between Normalization and De-normalization?

0 Answers   TCS,

---

Differentiate between a local and a global temporary table?

0 Answers  

---

hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution

2 Answers  

---

What are the different types of collation sensitivity?

0 Answers  

---

What is the downside of using udf?

0 Answers  

---

Explain features of analysis services?

0 Answers  

---

What is log shipping?

0 Answers  

---

What is the usage of the sign function?

0 Answers  

---

Write a SQL query to make a column as unique?

0 Answers   Cap Gemini,

---

what is the maximum size of sql row in mssql?

1 Answers  

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

0 Answers  

---