Gail

Yes and the 1500ms is just me filtering out quick running(ie < 1500ms) queries

I have 100s of inserts for this command(Sp_excute_SQL from .net EF4)

I run the Load Test for...

David

I have been coding to databases for nearly 30 years. (I don't come from America(nth, sth or in between))

And I agree with you about most "designers". They need a re-education...

David

So I and my customers invest in RAP(if not money, then time and effort) and rely on your assurances.

We do this for months or years.

Then we need to build a...

David

I just would not attempt to build an application or framework that is

"generically applied to all reasonable-sized database-based apps and generate most of the code for you"!!

I, and many others,...

David

I think your approach is Ill convieved and out dated.

Today we write applications for the Enterprise or for the Sector(eg small retail).

All the "Aspects", "Prespectives" and "Viewports" of software architecture...

It is not true to say that:

"Unfortunately in this day & age we still don't have relational databases that allow us to divide our various objects into different name...

SSC Veteran

I actually new that so I am not compressing the snapshot.

Any other clues or limits that I should be aware of

Well, Snapshots are used to initialise or reinitialise Merge and Transactional replications

The snapshot that I am using for reinitialisation of a merge replication, every 14 days, has grown so now...

I don't think that last statement is correct else how would a Merge replication get started if that merge replication was not connected to the distibutor eg done by CDROM/DVD?

Well I tried that and it did work.

But I am trying to do the Encryption on a INSERT or UPDATE of a table

When I put the OPEN MASTER KEY/Encrypt statements...