Answer Posted / yoshita kundwani

Cursors can be considers as named result sets which allow a
user to move through each record one by one.

Explain query editor regions

1005

---

How to change the ownership of a schema in ms sql server?

1094

---

What do you mean by an execution plan? How would you view it?

871

---

What is index, cluster index and nonclustered index?

930

---

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

139

---

What are the drawbacks of reporting in ssrs?

141

---

What is the difference between row_number and dense_rank?

827

---

What is a rollup clause?

910

---

Write a program using SQL queries to find a unique entry in a table.

943

---

how to control the amount of free space in your index pages? : Sql server database administration

985

---

What is explicit cursors?

991

---

Why should you use or avoid select * statements?

969

---

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1029

---

What is shrink log file?

847

---

How to execute a sql statement using mssql_query()?

977

---