Yeah, understood - this is an application database only. No reporting requirements or indices on this database.

Sorry to bring up an old post but I thought I'd add to the enclosed script by including schema names...

--1. get all indexes from current db, place in temp table

select

...

Thanks for all the guidance and help.

I have plenty to be going back to them with and might even change some indexing on the primary tables and prove the performance...

Thanks, perhaps a bit more background is in order.

The database was originally built years ago in Progress (old OpenEdge) but some Clients run it through the OpenEdge SQL DataServer which...

Yeah, sorry should have said ud functions... 🙂

Thanks for the quick reply.

And thanks for the suggestion with the money data type.

I understand what ISNUMERIC is used for; that was just an example.

I was just trying to save...

Apologies for taking a while to post on this topic and thanks for the interest and offers of assistance.

I started writing the DDL and sample code last night (it was...

Apologies, when I posted the original post it was very much the end of the week for me. I didn't have SSMS in front of me and my missus was...

Lowell (5/17/2011)

---

Don't Panic: MERGE is just a fancy way to do what you've already done a zillion times:, but as separate steps...INSERT new rows, UPDATE matching rows, DELETE rows that...

Lowell (5/16/2011)

---

dumb question time: can you do the ETL to a staging database, and then use MERGE or other methods to get the delta changes to push out? or is...

Craig Farrell (5/16/2011)

---

I have a few other questions about what you're dealing with here, and to clarify I understand your process.

Let's start with the staging table. It's a bulk...

The ETL process takes anywhere from 30 mins to 8 hrs dependant on hardware and size of the source database.

Thanks, unfortunately this is a released product with about...

Lowell (5/16/2011)

---

for me the big question is the number of rows moved;

when your procedure was running once a day, what did it do? MERGE statement? drop and recreate the...

Welsh Corgi (5/16/2011)

---

1. With Triggers you are going to have a lot of overhead

2. With SQL Broker you going to have to write a lot of code to extract the...