As for one being faster than the other, I would suspect that the answer is that they're exactly the same as the optimizer is going to do it's thing either...

Have you fired up perfmon and or any SAN client tools yet and taken a look at the various disk counters, etc.?  Even the magic SAN has limitations/gets busy and...

Watch the blinky blinky things while the process is running?  Just kidding, what kind of storage does your server use DAS, NAS, iSCSI, SAN?  If you're running NAS or iSCSI...

I would agree with Matt, CLR integration is just the ticket for this type of requirement.  As for notepad, check your task list with show processes from all users checked...

Have you tested it yet?  Another compression product, not Red Gate, had some real problems with a restore of a full-text index to another location last time we tried it -...

You need to talk to the admins of your SMTP server, the error message you are receiving "Mailbox unavailable. The server response was: 5.7.1 Unable to relay for YourMom@hotmail.com"...

Could very well be a latency/network issue - particularly with 1500 miles between the client and server.  Run a ping -t at the same time as your other test and see...

Sam -

You can get your data back to SQL 2000 via DTS or SSIS package as long as the collations, table structures, etc. are all compatiable with SQL 2000 (no...

What version of Oracle are you loading to, using which drivers? 

Joe

Pretty much the same way assuming you're using an OleDB data source, you can then specify the query to run.  Be sure to include column names for all of your...

Believe it or not I don't know the current name of his company, they recently got bought by much larger company - so the 8 weeks may be a thing...

Libby -

You can export reports in a variety formats including CSV the challenge is that .CSV files are mapped to Excel by default, which as you've noted can only have...

I agree with Rudy - run not walk from these folks.

Find an employer who recognizes your potential and will then train you for it on their dime/time. 

That said, there's...

The ultimate argument for using stored procedures is "re-use", which is something developers understand (at least in theory).

In my experience, it is not at all unusual for the database to...

Rudy -

You are only worth what you are willing to ask for - I don't work for less than X, period.  Yes, there is some risk that nobody will be...