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

What is the purpose of indexing?

1044

---

Explain steps of normalization?

1004

---

Explain index in sql server?

1012

---

Define tool Manage Statistics in SQL Server 2000 query ?

1093

---

Describe the left outer join & right outer join. : sql server database administration

996

---

What will be query used to get the list of triggers in a database?

1002

---

How you can get the list of largest tables in a database?

1014

---

role of sql sever 2005 in database rather than any other database

1939

---

When multiple after triggers are attached to sql table, how to control the order of execution?

1049

---

What is raid and what are different types of raid levels?

1149

---

query processing

2166

---

What is it unwise to create wide clustered index keys?

1007

---

How do you run a trace?

901

---

How many types of schemas are there?

1041

---

Explain what is the main purpose of having conversation group?

934

---