Answer Posted / suvek samyal

>clustered index store the actual data.
>one table can only have one clustered index because
clustered index is the actual table stored in order of the
clustered key.
>usually primary key used as the clusted key,but we can
also take the combinition of first name and last name as a
clustered key.
>printing phone directory is the best example of clustered
index.
-->non-clustered index is just like a pointer to the data.
-->one table can have upto 249 non-clustered indexs because
it has the pointer of actual row.
-->page no.,google search and other search engines used as
a pointer of non-clustered index.
-->the index in the back of a book is the best example of
non-clustered index

Can You Use Data Mining Models In Ssrs?

141

---

How can I create a new template for import ? : sql server management studio

1041

---

How to get a list all databases on the sql server?

1037

---

What is the usage of sign function?

1052

---

What are the key configuration files for sql server reporting services ?

163

---

Can We Use Data-grids For Our Report In Ssrs?

180

---

what happens on checkpoint? : Sql server database administration

1036

---

What are the disadvantages of using the stored procedures?

1035

---

Difference between Logical Page and Physical Page in SSRS.

462

---

What is normalization of database?

1034

---

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1029

---

What are the dmvs?

959

---

How to round a numeric value to a specific precision?

1033

---

Can we use max in where clause?

891

---

Can we use custom code in ssrs?

1074

---