[dba-SQLServer] Views

Any help on this one? Anybody? How do you count the number of rows pulled by 
the view? Count()'s going to return the number displayed -- how can I count 
the underlying number to determine if it's the same? I'm at a total loss on 
that one.

Susan H.


> That is my understanding of the documentation, Susan. The view pulls
> everything to the client, which then filters out everything not 
> interesting.
> I could be wrong about this but it would be relatively easy to generate a
> test. Unfortunately, today I have lots of work on my plate, but by 
> tomorrow
> I will have a 50M row table on which to test this hypothesis.