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.

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---

How to automatically create a log when an exception is being received into SQL Server?

0 Answers   Cap Gemini,

---

how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.

1 Answers  

---

How to delete database objects with "drop" statements in ms sql server?

0 Answers  

---

How cand Optimize SQL Server Stored Procedures

1 Answers  

---

What is user defined datatypes and when you should go for them?

0 Answers  

---

How to find the date and time of last updated table?

3 Answers  

---

Will sql server 2005 allow you to reduce the size of a column?

0 Answers  

---

How to loop through result set objects using odbc_fetch_row()?

0 Answers  

---

How to find the last update record in SQL Server?

4 Answers  

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

0 Answers   MCN Solutions,

---

Can you explain what is the use of custom fields in report?

0 Answers  

---