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 are a scheduled jobs or what is a scheduled tasks?

848

---

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2321

---

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

914

---

What are commonly used odbc functions in php?

971

---

What is sql view?

954

---

What is cached report?

135

---

What is the difference between function and stored procedure in sql server?

987

---

How would we use distinct statement? What is its use?

1023

---

Does sql server 2000 full-text search support clustering?

814

---

Detail about query optimizer?

1036

---

Difference between uniqe index and uniqe constraint?

916

---

What are synonyms?

913

---

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

975

---

What is the difference between getdate and sysdatetime?

941

---

Can select statements be used on views in ms sql server?

1002

---