Add I must that article to the library in my sig block.

Curious am I as to your question.

river-653653 (9/29/2009)

---

My database as 430 MB in the data file and 10GB in the Log file.

I want to live the database in full recovery model, because i want to be...

river-653653 (9/29/2009)

---

Hi,

I have a database in SQL Server 2000.

This database is in full recovery model.

The log size is now of 10GB.

I have made a backup of the...

What GSquared is alluding to with his sample code is that it would help if you would show us your code. It would be much easier to help you...

Jack Corbett (9/28/2009)

---

I think in the case being pointed out by Sliverfox, that the answer was a little brief, but not necessarily inappropriate. I would have probably would have...

Michael Valentine Jones (9/24/2009)

---

Lynn Pettis (9/24/2009)

---

Taking Michael Valentine Jones version and making it a bit more the way I'd write it, it would look like this:

select

...

Sergey Vavinskiy (9/24/2009)

---

The UPDATE/DELETE/INSERT may not even be able to complete the respective action because it can't get the required locks due to the locks put on the rows/pages/extents/table as...

Sergey Vavinskiy (9/24/2009)

---

I also think you missed the point, as Steve pointed out, only changes are logged. A simple, or complex, select statement for a report is only reading the...

Sergey Vavinskiy (9/24/2009)

---

Lynn,

If it is only one process running against this DB,...

Also, could you repost the DDL? I had them for a while yesterday, but I opened them directly and did not save it on my system.

Could you post the execution plan of the query without the index hints? That would probably be much more helpful in solving the problem. What appears to be...

Curious, how does a SELECT statement fill a transaction log? I can understand UPDATE, DELETE, and INSERT; but SELECT?

If your database is using the full recovery model, you really need to setup transaction log backups. This will keep your transaction logs from filling up your log drive....

Taking Michael Valentine Jones version and making it a bit more the way I'd write it, it would look like this:

select

a.DT,

...