Answer Posted / kaushik ganguly

We know sql server creates a clustered index by default
when we create a primary key. If you create a PK first and
then try to assign a candidate key a clustered index then
it is not possible bcos sql server allows one clustered
index per table.

But...

If you make a candidate key a clustered index and then
define the primary key sql server doesnot create clustered
index for the Primary Key column.

So the answer is yes...you can create a clustered index on
non-pk column :D

What is dirty page?

973

---

Difference between report and query parameter.

1100

---

How you can get a list of all the table constraints in a database?

956

---

What are the advantages of user defined function?

986

---

What is the sql profiler?

941

---

What is stored in the mssqlsystemresource database? : sql server database administration

1032

---

Describe and explain about SQL native client?

1109

---

Explain index in sql server?

1015

---

What is exporting utility?

1022

---

What the different components in replication and what is their use?

953

---

What is the contrast between sql and pl/sql?

1142

---

How to get a list of columns in a view using the "sp_help" stored procedure?

1033

---

What is sql sandbox in sql server?

1226

---

What is dbcc command in sql server?

1093

---

Where do you find the default Index fill factor and how to change it?

1063

---