Answer Posted / shailesh arban

Because cluster index sort data in table based on key value that is you primary key value and primary key values are unique in table therefore cluster index only one on table.

What do you understand by integration services in sql server?

996

---

Explain the disadvantages of cursors?

1200

---

What is sql azure database?

206

---

Does group by or order by come first?

996

---

Difference between report and query parameter.

1139

---

How to list all field names in the result set using mssql_field_name()?

951

---

What are the new scripting capabilities of ssms? : sql server management studio

1114

---

What are extended events in sql server?

1002

---

Explain how you can deploy an SSRS report?

156

---

What is stored procedures?

1106

---

What are Spatial data types in SQL Server 2008

1064

---

What is the language structure to add a record to a table?

1073

---

New concepts of sql server 2005 use in your project.

2399

---

Why use “in” clause in sql server?

1116

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

1002

---