Thank you for the reply and understanding my design puzzle. I understand what you've suggested, but i think that would then end up doubling/tripling/X-ling the various fact measures i have...

thanks. i have tried debuggin in VS on my local machine, but i've got a fundamental issue of trying to work out which oracle drivers i need in order for...

ok so LIKE:

select * from table where description LIKE '%ear%'
would return row with "ear", "ears", "bears", "years", "earth", "my ear hurts", "my ears hurt", etc

now...

yes i've been using contains. The LIKE does return the row. Contains doesn't.

thanks if you can, please do. i have started having a play with bulk insert...

thanks, but my source is a text file supplied by a 3rd party, something they produce. so i have no control over the production of that.
i'm not bcp'ing out,...

Thanks all. So a sample from the supplier documentation re the schema of one of the flatfiles...

thanks. we have cozyroc, i'll take a look as to how much better they could be.

No, the target tables are not yet defined/created either.

There's 5, some small 2or 3 tens of GB.

Great. Thanks. Yes thought about mirroring instead. Have to now because DB doesnt have primary key on every table anyway. Thanks again.

Thanks for your reply. That's reluctantly acceptable - what about hiding the other system DBs and user DBs? If msdb has to be visible then that's fine.

Lovely stuff. thanks. 🙂

Thanks very much for the quick reply Gail.

Ok thanks for the quick reply.

What are the security concerns around either ?

great stuff. thanks a lot for the help. much appreciated.