Great solution.

Just a question: why a join and not an IN clause in the WHERE statement of the top SELECT?

It should save I/O time not having to pull from the...

Thanks for reply,

I think I can retain NT Admin password, and just give the password of the login owning the actual db.

Does it look feasible a double DB structure with sensible data and...

Seams really simple and interesting

But what about performance issues?

Using the view that makes the UNION instead of the BigTable would degrade performance or may instead boost it?

How should the constraints...

Where can I find more info about

"dbcc showcontig, sp_spaceused"

"dbcc freeproccache "

and a "How To" on performance tuning

Regards

Giovanni