Answer Posted / yashpal

Clustered index will be created by default when u
create primary key on a column. only one clustered index is
created per table

Non clustered index will be created automatically when u
create unique key on a column. A table can have no.of
unique keys, so we can create no.of non clustered indexes
per table.

Do comments need to go in a special place in sql server 2005?

866

---

Explain what is the function of sql server agent windows service?

1001

---

What to check if a User database is locked?

1080

---

Can we call future method from queueable?

1063

---

What is indexed view?

989

---

Delete duplicate rows without using rowid.

1540

---

How do I view a procedure in sql server?

999

---

Tell me can we use custom code in ssrs?

1012

---

Tell me what is difference between view and materialized view?

947

---

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

2005

---

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

989

---

Which data type columns are the best candidates for full-text indexing?

975

---

What do you mean by table and field in sql?

1019

---

What do we have to check in database testing?

1026

---

What is a schema in ms sql server 2005?

982

---