Answer Posted / veerreddy

clustered index is that the order of data in table is always
equal or matches to order of data stored in index.there is
only one(1) clustered index for table.it is usually applied
on primary key column in table.

other hand the non-clustered index is that the order of data
in table is not equal or matches to order of data stored in
index.so they can be applied on non-primary key columns like
unique,foreign key etc.A table can have (249) non-clustered
indexes

Tell me about builtinadministrator?

1001

---

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

979

---

Explain candidate key, alternate key, and composite key?

1003

---

How to divide query output into multiple groups with the group by clause in ms sql server?

1040

---

Why people hate cursor?

1148

---

What is buffer cash in sql server?

1154

---

Can group by be used without aggregate functions?

924

---

What is sql server schema compare? How we can compare two database schemas?

1031

---

Can I save my report as html, excel or word? : sql server management studio

955

---

What is the maximum size of column in sql server?

893

---

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

137

---

Explain about link server in sql server?

1061

---

What are the characteristics of modern DBMS?

1092

---

Please illustrate physical database architecture? : SQL Server Architecture

988

---

Do you know what is sql injection?

999

---