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.

Explain steps of normalization?

974

---

Which rendering formats are affected by the pagesize properties?

144

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2060

---

Can we use having clause without group by?

959

---

What are the advantages of the mirroring?

1058

---

Explain triggers in sql?

927

---

How does a profiler work?

906

---

Define clusters?

1035

---

What is bulkcopy in sql?

932

---

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

894

---

Write an sql query to find first weekday of the month?

899

---

Can you please explain the difference between function and stored procedure?

988

---

Does partitioning improve performance?

949

---

What are user-defined functions (udfs) in sql server?

969

---

How to filter out duplications in the returning rows in ms sql server?

1113

---