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.

What are SSL and TSL protocols?

0 Answers   Wipro,

---

What are the requirements for sql server 2016?

0 Answers  

---

What are the underflow and overflow behaviors on float literals?

0 Answers  

---

What is acid mean in sql server?

0 Answers  

---

What is the Control Flow in SSIS

0 Answers   HCL,

---

Explain transaction server auto commit?

0 Answers  

---

What's the information that can be stored inside a bit column?

0 Answers  

---

What is the difference between implicit and explicit transaction?

0 Answers  

---

can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3

15 Answers   Google,

---

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

0 Answers   IBM,

---

What is equi join with example?

0 Answers  

---

Explain what you mean by 3 tier architecture.

0 Answers   TCS,

---