' else build your own logic to check and insert new rows.' Yup, I think that's the best course of action. Cheers
The only problem is that the data will be periodically removed from the source (the destination is an archive) - when I selected 'replace' instead...
Hello,I have two tables in my database that I need to copy all the data frominto a seperate database. Once data is copied, it is to be deletedfrom...
Hello, I am dbreindex'ing my database at the moment but am getting a sideeffect I cannot explain. Upon running showcontig on the reindexed table, the...
That's great - on with the execution plans i go <img src='/community/emoticons/emotion-2.gif' alt=':D' /><br />Cheers,<br />max
Thanks for your replies both, Roji - I thought that the pointer for each row in the non-clustered index would make queries faster when running...
Hello, I have what I can only describe as a 'heap' that I need to positively increase the performance on. I will need to create a composite key as no...
Separate names with a comma.
