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.

Repair mdf file

2 Answers  

---

How do you delete a data source?

0 Answers  

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  

---

which one will take 1st priority in case of insert statement and select statement???

2 Answers   HCL,

---

What is an identity column in insert statements?

0 Answers  

---

---

What command do we use to rename a db?

5 Answers   IBM,

---

Why people hate cursor?

0 Answers  

---

What is indexed view?

0 Answers  

---

How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

How check triggers in sql server?

0 Answers  

---

What is difference between commit and rollback when used in transactions?

0 Answers  

---