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.

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 Answers  

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

0 Answers  

---

What is the importance of three tier architecture?

0 Answers   QuestPond,

---

Can you pass expressions to stored procedure parameters?

0 Answers  

---

What is a periodical index?

0 Answers  

---

What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,

---

Determine when to use stored procedure to complete sql server tasks?

0 Answers  

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

0 Answers  

---

What are the different types of replication? How are they used?

3 Answers  

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

0 Answers  

---

Do you know what are the ways available in sql server to execute sql statements?

0 Answers  

---

What is the difference between function and stored procedure in sql server?

0 Answers  

---