there is the wrinkle of refills i did not expose earlier (and there are really two date fields at play, date written, date filled, with number of refills and days...

my feeling is that using an identity without a syntactic uniqueness check makes the primary key a tautology because there can exist syntactically identical rows (i mean two rows that...

indeed, the question at hand is for the compund case; Member, RX, NDC, Day, Provider and Status offer lots of opportunity to fall off the wagon <g>

thanks very much...i got here because an associate happened to notice a duplicate row in a pharmacy feed. i asked them how could it be that a duplicate could get...

Agreed,

i may be too mechanistic in the approach.

thanks very much.

drew

a candidate key is an attribute or attributes that do not have more than one row in a relation. a primary key is the chosen candidate key that dovetails most...

Thanks very much everyone for taking the time to give me advice.

Data services, project managment and development met today and made a two step deal; we are going to...

MyDoggieJessie (3/18/2012)

---

To aid what everyone else has already said (especially noting that some tables are only used monthly/yearly, etc), depending on how frequently you restart your MSSQL servers you can...

they don't.

its a sad fact of life...there's ten years of zero pedigree spinning

ok, I think im ready.

thanks very much for the orientation.

drew

thanks very much Lutz;

I was in the throes of responding before i saw your reply...

like Meatloaf, you took the words right out of my mouth!:-D

thanks again

drew

thanks very much;

one follow up and a lttle whine for breakfast <g>...first the follow up

1) the limits of my knowledge dictate that profiler and triggers can have an impact in...

Found it.

Apologies for the noise.

drew

i hadnt thought about much of what you raised (content vs schema, context vs last transaction); thank you for taking the time to write this, i appreciate it.

drew

i wanted to understand where they differ. now i think replication lets you select whether you trap final state or all changes where CDC traps all changes.

thanks again

drew