Recovery takes longer than the action itself.

The server has to read the transactionlog, apply the redochanges (which are logged also?).

To delete something from large tables it is benificial to do...

also check out the firewall settings

http://msdn.microsoft.com/nl-nl/library/cc646023(SQL.100).aspx

Probably not. So many opportunities, so little time.

Have a look at

http://www.issociate.de/board/goto/766405/installing_msde2000_for_remote_connection.html

Is sql2000 the msde version?

From SP3 on there is some extra configuration work for remote connections.

As far I remember is /3GB -> 3GB to share amonst all programs, 1GB for OS.

If you have 2 instances, AWE could be a solution as it allows a buffer...

Interesting question

Have a look at http://www.devcurry.com/2010/08/free-text-editors-to-open-large-text.html.

Notepad++ chokes on big files (+100 mb)

I'm also looking for a detailed walkthrough. Myself I usually go through:

1. Install Oracle 64-bit client (11gR2) with Administrator option (not InstantClient, in order to diagnose connectivity), to make sure...

An old trick is to create a composite index with an additional not null column.

Normally, there are no statistics for NULL-values. By adding a not null column you semi-force them...

good to know

Any clue where Select * from CLEAR.CLM_EDIT_WQ_CLM came from?

Is EXTRACT_DATE a date or timestamp?

other sources report making a view so every oracle column is converted to a...

Hello,

You'l have to check some things.

Does the basic oracle connectivity works using tnsping, sqlplus from the server?

Is the server 64-bit? In that case you might need both the 64-bit and...

Apparently changed with oracle 10g

http://decipherinfosys.wordpress.com/2007/04/28/writing-data-to-a-text-file-from-oracle/

No direct unloader

Have a look at the faq

http://www.orafaq.com/wiki/SQL*Loader_FAQ#What_is_SQL.2ALoader_and_what_is_it_used_for.3F

or try to write to "external tables"

Verify that the adtime can be converted to a datetimeformat as you use it to extract the hour & minutes.

select datepart(hour,convert(datetime,adtime,8))

The sqlagent (user) has access to the share?

Almost.

What culprit did your boss fix?

Can you make a connection to the oracledatabase outside SSIS?