[dba-SQLServer] Views

> SELECT * FROM MyView WHERE PK = 124
>
> results in the case of a view that all rows in the view are sent to the
> client and then the client filters the result set.

=======Arthur, I'm not sure I understand -- are you saying that if MyView 
contains 100 records but only 2 that satisfy the WHERE clause, the view 
still pulls all 100 records but only displays 2?

Susan H.