I know this is old, but just in case anyone needs it. Looking in the master db and MSDN, I found sp_delete_log_shipping_secondary_database stored proc. Running this removed the...

I've been meaning to take a look at SQL Sentry Plan Explorer for a while now. I installed it today and it looks like it solves my biggest problem...

So to summarize:

Separate (normalized) tables:

PROS:

- Much more flexibility in assigning phone numbers to employees.

CONS:

- Slightly more complicated and slightly more costly to query

One table (denormalized):

PROS:

- Simpler queries

- Slightly faster queries

CONS:

-...

RBarryYoung (3/27/2014)

---

OK, here's my crazy, shoot-from-the-hip shortcut idea:

1) Make a new schema in your source DB called [Export]

2) For each table to be exported, create a View in [Export] named...

If I understand what you mean by overlaps in the referential data, then yes there are. Without going into the specifics, both databases have a table called Person with...

Thanks for the reply, but I think you're missing one part of my scenario or I'm not quite understanding your answer. The problem with your answer is that I...

Ok, I'm doing a reorg on both large tables and given that we've always done "smart" index maintenance on our read-write servers it's very interesting to see how much longer...

There are a handful of tables in the database but one of them is about 80% of the data and another is about 15% so those two tables hold most...