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.

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

0 Answers  

---

Explain trigger and its types?

0 Answers  

---

How to create new table with "create table" statements?

0 Answers  

---

what types of replication are supported in sql server? : Sql server database administration

0 Answers  

---

what are the limitations of parameters in a storedprocedure

1 Answers  

---

Do you know what are the steps to process a single select statement?

0 Answers  

---

What are the grouping functions?

0 Answers  

---

In join, which clause in not used?

4 Answers   HCL, NIIT, TCS,

---

What are a database and a data warehouse?

0 Answers  

---

What method is used by the Command classes to execute SQL statements that return single values?

0 Answers   B-Ways TecnoSoft,

---

what is the maximum size of a row in sql server 2000 and 2005

2 Answers  

---

How to get last system shutdown time in Sql server when restarted system?

1 Answers  

---