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.

Do you know what is replace and stuff function in sql server?

0 Answers  

---

what is the difference between group and having give an example with query and sample output

7 Answers  

---

What are the limitation of the Online Index Rebuild Operation?

1 Answers  

---

Does sql server 2000 full-text search support clustering?

0 Answers  

---

What are the options which must be set to allow the usage of optimistic models?

0 Answers  

---

ow to bring suspect mode datbase online from scratch

0 Answers  

---

how can i store resumes in database?

3 Answers   HCL,

---

how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.

1 Answers  

---

Which sql server table is used to hold the stored procedure scripts?

0 Answers  

---

What do you understand by physical_only option in dbcc checkdb?

0 Answers  

---

How to disconnect from a sql server using mssql_close()?

0 Answers  

---

what are the new features of sql server 2005?

8 Answers   HP, Keane India Ltd,

---