Answer / samba shiva reddy . m

The job of the lazy writer is to find dirty pages in the buffer pool and write them out to disk and drop those pages from cache. It does this to keep a certain amount of free pages available within the buffer pool for data that may be requested by other queries. The pages that it writes out are ‘older’ pages, ones that haven’t been used for a while.
If there’s lots of available buffers, the lazy writer will be doing relatively little work and the number of pages written to disk will be quite low. If the lazy writer’s consistently writing lots of data, it may indicate that there’s a memory bottleneck.

What is the difference between the 2 operating modes of database mirroring?

0 Answers  

---

What is the difference between mysql and mysqli?

0 Answers   HCL,

---

What are the different types of queries?

1 Answers  

---

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

0 Answers  

---

What do you do in data exploration

0 Answers   EXL,

---

Tell me what is the stuff and how does it differ from the replace function?

0 Answers  

---

how will add additional conditions in sql?

0 Answers   Amdocs, Apps Associates,

---

Define constraints and give an example of their use?

0 Answers  

---

Explain the types of indexes.

0 Answers   Accenture,

---

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

---

What is an indexed view?

0 Answers  

---

what are the new features of sql server 2005?

8 Answers   HP, Keane India Ltd,

---