From an architectural point of view, you may want to look at splitting across functional areas. So have a dedicated resource for ad-hoc BI, another for EDI, etc. ...

I wouldn't expect much (if any) performance gain from moving the archived tables to a separate database. If the archived data is not being accessed, then it's not generating...

Can't remember whether it was introduced in SQL 2005 or 2008, sorry.

Now, if you really wanted something to think about... try thinking about being able to pass a set...

Well, you could probably do both of those with one MERGE statement. Either way though, they are one logical thing (you add a record), and you always get the...

It's not necessarily a good thing that Oracle makes it so easy to write cursor-based logic. It does do some smart things with the foreach turning the logic into...

How quickly would I need to duck if I recommend Joe Celko's books? 😀

The best way to learn is almost always to do, but a great book certainly helps...

Okay, I guess I am a little puzzled.

The examples all seem to be around a developer producing code that's fine in development/test environments, but bombs in production. So we...

While I think SQL Server is smart enough to deal with the execution plans for the different parts of the code, writing stored procedure logic this way isn't a great...

Somehow, I am unsurprised that this thread is still going...

Admittedly I haven't played with anything post 10g, but in my 15 years of Oracle DBA work, I haven't met a version of Oracle with a case sensitive password. ...

Oracle's usernames and passwords are case insensitive, btw.

Bulk insert will work fine for getting the data into SQL Server; the trick is getting the data out of Oracle quickly.

I'd suggest two choices:

The "Connected" Model

Look at Integration Services...

[font="Verdana"]In versions of SQL Server prior to 2005, I emulated it using an identity field. Since then, I use row_number(). Neither is exactly equivalent, but for what I've...

[font="Verdana"]How are you loading up the data into your data warehouse ETL? Are you using SSIS, bcp, bulk insert? If so, those options are likely to be minimally...

PaulB (8/13/2009)

---

Bruce W Cassidy (8/13/2009)

---

You can, of course, create multiple Oracle instances. There used to be a great deal of overhead in doing this, but with modern versions of...