Nah, they need to redo your walk in for this one! :hehe:

SQL Kiwi (1/27/2012)

---

Ah, I see. Thank you. Actually I know very little, but what I do know...

You know too much, you must be alien or something :alien:

No way around it now, I'll have to ask for a urine test Paul.

:hehe:

UNION <ALL>

acts a bit like a derived table. You can only put ONE order by and it will by applied after the union has been processed.

I've had...

Why not just truncate / insert?

If not possible, why not merge?

GilaMonster (1/24/2012)

---

Full backups will take longer than they should. Log backups take longer than they should. Large transaction rollbacks may take longer than they should. Restores will take longer than...

What's the speed gain you get from the rebuild?

This might be a case where not doing the rebuild is your best option.

Reorg is online operation so your system stays available...

Brandie Tarvin (1/23/2012)

---

For those of you who are buying, we'd also appreciate tags or reviews (or both) posted to the book links. Be honest. While we would love 5 stars,...

Learn more, read / join the...

Not enough information to help you.

Likelier a shrink in the maintenance plan.

Please post the actual execution plan.

What she means by this is did you run restore WITH RECOVERY.

If you didn't you can try to do so now (assuming you don't need to restore tlogs as well).

RESTORE...