Jeff Moden (2/18/2014)

---

cygne17_2 77208 (2/18/2014)

---

Hi,

I found a sql server database with a transaction log file of 65 GB.

The database is configured with the recovery model option = full.

Also, I noticed...

boring

Browning

It appears you are running the same query in 2 different where clauses. If I were to tackle this I'd consider restructuring the code so this result set:

select...

jcrawf02 (2/11/2014)

---

Ed Wagner (2/11/2014)

---

BWFC (2/11/2014)

---

SQLRNNR (2/11/2014)

---

Ed Wagner (2/11/2014)

---

BWFC (2/11/2014)

---

Ed Wagner (2/11/2014)

---

SQLRNNR (2/10/2014)

---

Ed Wagner (2/10/2014)

---

SQLRNNR (2/10/2014)

---

Stuart Davies (2/10/2014)

---

Day...

Fudd (Elmer J)

Pot

Skeet

If your database recovery model is FULL then you simply need to schedule a job to backup the transaction log. If it is set to SIMPLE then you probably...

glaze

As Luis pointed out the conversion works fine with the sample you have. Maybe there is an instance of data that doesn't contain a valid entry or simply IS...

What else do you have running on that box? 8gb alone should be plenty to keep the OS happy. However if there is something else requiring extra memory...

Jeff Moden (1/28/2014)

---

You can actually control what order everything is done by triggers. Note that I did NOT say you could control the order of triggers (other than the...

à point

I have several databases that are mirrored. A few have a witness server and a few don't. Initially I set up all of the databases with witnesses until one...