So do you mean that the 2nd option of ours will have the fragmentation poorly affecting performance by design?

1) I noticed that there are some political issues in this respect. And we have to prove absolutely that it will have poor performance. So far we might not consider...

Thank you. This sounds like a very good approach. Let's think.

Pros:

- Normal way of table design

- Generally better performance

Contras:

- We need a XML column in every table (may be considered as...

Thank you. It is supposed the view DDL code will be generated automatically from the meta data too. Deleting of columns would be disallowed since they may be used by applications...

It's not for a bank, it's for a retail company.

BTW, after we moved the testing environment to a more powerful server the time for the detached attribute model queries reduced...