>>I'm grimacing at my spelling errors. It must be this funky keyboard. Yeah that's it. Ok. But if you are using views to represent entire tables don't you suffer a big performance penalty.
>
>exactly - this is why you never retrive more than the bare minimum records you need in any query you issue. That's what parameterized views are all about..
>
>Arnon

So your answer is to use all parameterized views. This will speed up the transition to a sequel server environment but will not suffer the performance hits because your are only looking at a slice of the data?

Dan