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 'Join' and explain its various types.

0 Answers   Genpact,

---

What are the essential components of sql server service broker?

0 Answers  

---

What is an index. What are the types?

0 Answers  

---

What are the differences between char and nchar in ms sql server?

0 Answers  

---

What is plan freezing?

0 Answers  

---

Explain the etl (extraction, transformation, and loading)?

0 Answers  

---

What new changes are being made in SQL Server?

0 Answers   Blue Star,

---

What is exclusive locks?

0 Answers  

---

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?

1 Answers  

---

What are the various Isolation levels?

2 Answers   HP,

---

What is the openxml statement in sql server?

0 Answers  

---

List out the different types of locks available in sql server?

0 Answers  

---