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

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

1024

---

What do you mean by authentication modes in sql server?

1128

---

Data table as parameter in sql server?

1100

---

Explain different types of collation sensitivity?

1028

---

What is the maximum size of a dimension? : sql server analysis services, ssas

1085

---

How global temporary tables are represented and its scope?

1011

---

How to enable/disable indexes?

1120

---

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1209

---

Explain trigger and its types?

1112

---

How many joins in sql server?

999

---

What is the difference between web edition and business edition?

113

---

between cast and convert which function would you prefer and why?

1010

---

What are the different types of join?

1237

---

can a database be shrunk with users active? : Sql server administration

1058

---

What is a database in ms sql server?

1101

---