Type faster 😉

Do just that and the DB will be...

ALTER DATABASE ... SET RECOVERY SIMPLE

Not that you should need to truncate...

Ok, I didn't see the earlier posting of the view. Nothing worrying there, I just wanted to check what exactly it was doing.

Slick84 (10/15/2009)

---

As far as your recommendation. I did...

wytze.sijtsma (10/15/2009)

---

blandry (10/15/2009)

---

In some ways, this is like buying a car and having some button or knob not clearly outlined in your owners manual. Imagine driving into a dealership...

No, but it tends to be most useful (and most...

Is this what you're asking about?

http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/

What?

Grant Fritchey (10/15/2009)

---

The one's that cause blood to shoot out of my ears due to overpressure are when you ask for clarification and they say "Never mind, I'll wait until...

Several options

Are you backing up to a network location? If so, backup to local disk

Check the performance stats on...

If you have autoclose on, yes. When SQL brings a DB online, it does restart-recovery. It has to.

That you're seeing if for couple...

ericwenger1 (10/14/2009)

---

thanks for you suggestion and please provide me more. I read your article, and I agree I don't want to make things worse with a repair option, but, I...

This one. What would be the point of conquering any other?

Before anyone gets worried...

http://www.galciv2.com/

Currently playing Altarians going for an ascension victory. Just need to do something...

s ss (10/14/2009)

---

GilaMonster (10/14/2009)

---

I need some help in getting data into a particular form. I have a table with three columns in. The first column is a code, the other...

Better, but not fantastic.

There's still a massive inaccuracy on the row estimation coming from tblRegularItems. I don't understand why. Try an update statistics with full scan on that table, even...