Hi

SP2 of Win2k resolved this issue for us. The DLLHOST.exe chewed around 30Mb then stopped there and cached nicely.

Cheers

Chris

Hi Andy

Thanks Andy, also found an article on it and will give it a burl. Ill have to be more thorough in reading up on the new features.

Cheers

Chris

Hi Hal

In my next article I chat about 3rd party software (like Crystral Reports 8.5) that insist on using the SA account and then retain its use (can be a...

Hi Lhot

Its a simple matter of the priviligies that go with the administrator login at an NT level that is the issue. I recognise the fact that it still...

Hi

Only problem we had is where programmers with retrieving the identity of the inserted row, but they kept retrieving the audit tables identity column instead, so we had to remove...

Steve

Point taken, our servers are $30k (aus) each, not including the external disk array. We will run some thorough tests on the RAM (30day money back) and see wat...

Hi

Its not a problem really, the DBA is the DBA and should be GOD when its comes the DB management and administration. To achieve this, only the DBA uses...

Steve

http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a88876/adgsec04.htm

basically pl-sql stored procedure routines, ie:

dbms_obfuscation_toolkit.DESDecrypt(input_string => encrypted_string,

key => raw_key, decrypted_string => decrypted_string);

for example.

Includes:...

In oracle there are built in obfuscation routines so no need to code your own 🙂

Anyhow, I agree that encrypting data in the DB is not the best practice in...

Dont have embedded CR LF ?? try a unixtodos on the file for double check.

Hi

We have dome something similar using stored procs and BCP via xp_cmdshell. its very easy to write with no major dramas. Only problem is the xp_cmdshell usage as...

Hi

De-attached DB's, uninstalled SS2k, complete re-install, attached DB's and applied SP2 without a problem..

Still none the wiser why it didnt work first time.

Cheers

Chris

Hi

Well not really, it comes more down to recovery time. Applying a series of logs will be slower than applying a single differential. I rarely use them but...

Hi

You can use hints, like you can in SQLServer to alter the plan, thats about it though. I would highly recommend against hints unless you have a good reason...

In Oracle, you can have the concept of a query re-write, namely with whats called materialised views in which it can alter your select to look up over some "pre-generated"...