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.

difference between truncate, delete aur drop?

2 Answers  

---

What are the differences between UNION and JOINS?

3 Answers   CarrizalSoft Technologies,

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  

---

What is the name of the Database which IBM mainframe uses?

0 Answers   Wipro,

---

What are different types of table joins?

0 Answers  

---

---

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

0 Answers  

---

what is the cursor life span?

5 Answers   Evalueserve, HG,

---

How is sql server used?

0 Answers  

---

What is the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---

Can you explain full-text query in sql server?

0 Answers  

---

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

0 Answers  

---

what is checksum in sql server.........???

0 Answers   TCS,

---