Answer Posted / ricky

when we create a primery key it automatically create
aclustered index. clustered index is a index which reorder
the records in a way the recored are physically sorted.
or
in clustered index the logical order match the physical
order.
whre as the non-clustered index the logical ordered of the
recored does not match the physical order of the recored on
disk.

How to use subqueries in the from clause in ms sql server?

1159

---

Explain the architecture of ms sql reporting service?

918

---

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

990

---

How data can be copied from one table to another table?

944

---

What are the database roles? : sql server security

1178

---

how to take backup bcp out for a column in table in sql server?

2102

---

What is query optimization process?

1007

---

What is the maximum size of a row in sql server?

966

---

What are the encryption mechanisms in sql server?

1026

---

Explain magic tables in sql server?

1055

---

What is the difference between dbcc indexdefrag and dbcc reindex?

981

---

How to count rows with the count(*) function in ms sql server?

1012

---

How to view existing indexes on an given table using sys.indexes?

1089

---

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

963

---

Difference between DELETE and TRUNCATE?

1047

---