In short yes you can.

Delphix creates virtual copies of a source databases. You can run DBCC CHECKDB as either a post provisioning step as part of the VDB workflow or...

>>Delphix is Oracle based even though it supports MS SQL now i would still be cautious.

>>Red-gate had a similar product which has gone into retirement SQL Virtual Restore.

>>It...

Thanks G! I will try to get thos things for you and post them back here tomorrow.

Thanks Phillip, R2ro and PW,

I created the clustered PK that R2ro suggested and the optimizer plan improved greatly. The update statement completed in 9 minutes, down from 4.5 hours. Pretty...

Thanks for the suggestions! I will try them this evening and let you know the outcome.

Steve

Greatly appreciated! Thanks Allen!

I has the 'set identity_insert' set to 'on'. I have turned it off on the offending transformations and I'm testing again. It seems to be working so far.

Thanks!!

Thanks Calvin,

Much rather have the elegant approach. I'll try it out.

Steve

Solved it myself. Thanks anyway.

delete from NA_ATTRIBUTE_DATA where NA_ATTRIBUTE_DATA.ROWNUM (select MAX(x.ROWNUM) from NA_ATTRIBUTE_DATA x where x.MONBR = NA_ATTRIBUTE_DATA.MONBR)