Answer / Pawan Kumar

You cannot manually clear the transaction log file in SQL Server. Instead, it automatically grows and shrinks as necessary based on transaction activity. To manage the size of the log files, you can set up maintenance plans or use scripts to perform regular backups and shrink the database.

what are the advanced features in sql 2008?

2 Answers   Wipro,

---

UPDATE statement can on a single table or on the multiple table?

7 Answers   iGate, TCS,

---

What is a constant or literal in ms sql server?

1 Answers  

---

What is data source view or dsv? : sql server analysis services, ssas

1 Answers  

---

What is named query? : sql server analysis services, ssas

1 Answers  

---

What is an expression in ms sql server?

1 Answers  

---

How to perform key word search in tables?

1 Answers  

---

Is Sql non procedural query language?

1 Answers   Verifone,

---

what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,

---

Explain Capacity planning to create a database? and how to monitor it?

1 Answers  

---

What is the sql case statement used for?

1 Answers  

---

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

1 Answers  

---