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

Explain about unique identifier data type in sql server?

922

---

Define Wed Edition in SQL Azure?

100

---

What are partitioned views and distributed partitioned views?

1024

---

What are security principals used in sql server 2005?

991

---

what exactly sql injuction.how to overcome.....

2548

---

Define Business Edition in SQL Azure?

100

---

How do I delete a sql server database?

1048

---

Do you know query execution plan?

1184

---

What is the cartesian product of the table?

958

---

What is the osql utility?

977

---

What is an index in a database?

983

---

Explain what are the database objects? : SQL Server Architecture

1086

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1920

---

Why is the need for data conversion transformations?

1072

---

Differentiate between a having clause and a where clause.

967

---