Answer / sachin nandanwar

Its a rubbish answer what adesh has posted.

Lazy writer and checkpoints are NOT related to each other.

Lazywriter will come into picture only when there is memory
pressure by changing the size of buffer pool or when it
periodically finds dirty pages which have not been used for
a while and flushes those pages to the hard disk.It drops
the pages from the buffer cache to free the cache.

Checkpoint on other hand also checks for dirty pages and but
will not drop pages from the cache instead will mark the
page clean in the cache after flushing it to disk.The
primary purpose of checkpoint is to keep the recovery time
as low as possible and not memory management.

Answer / adesh saunakiya

Lazy writer function is to write the data pgae from buffer
log to Master data file in cordination with checkpoint
because data page having counter which is refresh it self
from 0 to 1 as the data page is commited its counter is set
to 1 and lazy writer scan the datapage continuosly as it
set to 1 it free the memory in buffer log and save that
page in to master data file physically.

i think thread are the part of a process.

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

3 Answers   SAP Labs,

---

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 the fillfactor concept in indexes?

0 Answers  

---

What is blocking?

0 Answers  

---

How to insert data with null values?

0 Answers  

---

What is the difference between having clause and where clause in sql server?

0 Answers  

---

Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer

3 Answers  

---

What is a cube? : sql server analysis services, ssas

0 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers  

---

What do you mean by sql server 2005 express management tools?

0 Answers  

---

How to sort query output in descending order in ms sql server?

0 Answers  

---

What is update_statistics command?

0 Answers  

---