Answer Posted / 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.

Does a specific recovery model need to be used for a replicated database? : sql server replication

943

---

what authentication modes does sql server support? : Sql server database administration

1070

---

What is a virtual table in sql?

976

---

Explain what are various ways to enhance the ssrs report?

1027

---

How do I view a trc file?

924

---

What are .mdf files?

922

---

How to transfer data from a cursor to variables with a "fetch" statement?

1070

---

Mention a few common trace flags used with sql server?

916

---

Explain how dts is used to extract, transform and consolidate data?

979

---

Explain Geometry datatype in sql server 2008 with example

956

---

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

1022

---

Do you know query execution plan?

1147

---

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

960

---

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

936

---

Explain what is the difference between union and union all?

989

---