Answer / Kumar Phanishwar

"Buffer Cache stores data pages from disk in memory, reducing the number of disk I/O operations. It improves query performance by keeping frequently accessed data close to the processor for quick access. Log Cache holds the log records that are waiting to be written to disk. It ensures data consistency during transactions and recovery operations."

What is the stuff and how does it differ from the replace function?

1 Answers  

---

How to enable tcp/ip protocol on a sql server?

1 Answers  

---

how to count datewise data in sqlserver

4 Answers   CarrizalSoft Technologies, IndusInd Bank,

---

can an order by clause be used in a creation of a view?

1 Answers  

---

How to use subqueries in the from clause in ms sql server?

1 Answers  

---

how you can get the list of largest tables in a database? : Sql server administration

1 Answers  

---

What is difference between TRUNCATE and DELETE statement

12 Answers   CTS,

---

If we use where clause in the left outer join then how the query would behave/act?

1 Answers  

---

How do you find the number of rows in a table?

7 Answers  

---

What is forward - only cursors / read only cursor?

1 Answers  

---

What is bcp? When does it used?

1 Answers  

---

What happens when transaction log is full?

1 Answers  

---