Answer Posted / ashok

we can creta clustered index on non primary column.
create table abc(eid int,ename varchar(50))
create clustered index abc_clustered on abc (eid)

Why we should not use triggers?

961

---

What is query cost in sql server?

987

---

what is database replicaion? : Sql server database administration

1179

---

Explain about the command-line tool SQLCMD?

1081

---

What are the disadvantages of merge replication?

1408

---

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1102

---

Mention the differences between having and where clause.

1054

---

What options are available to audit login activity? : sql server security

1145

---

What is the order by used for?

1015

---

What do you mean by a Composite primary key?

1093

---

What is user-defined multi-statement table-valued function?

1051

---

What is similarity and difference between truncate and delete in sql?

1089

---

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

974

---

Can we return Data from 4(more than 1) tables in stored procedure?

1051

---

How can we check the sql server version?

1053

---