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

Is port 1433 secure?

538

---

What is the openxml statement in sql server?

536

---

What is ms sql server triggers?

535

---

How to concatenate two character strings together?

567

---

Is null in sql server?

544

---

---

How fixed length strings are truncated and padded?

550

---

What is a collation?

594

---

What is a sql join?

573

---

Explain the Ways to improve the performance of a sql azure database?

64

---

How many clustered indexes there can be on table ?

601

---

What are the approximate numeric data types?

531

---

In how many ways you can invoke ssrs reports?

102

---

What is SQL Azure Data sync?

103

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

551

---

Do you know the policy based administration feature of sql server 2008?

576

---