[dba-SQLServer] Strange happening

I think that you could modify the index to include the NewID() column as
Stuart suggested, and get the results you want. Alternatively, SELECT TOP n
* FROM yourView ORDER BY NewID().

A.

On 2/28/08, jwcolby <jwcolby at colbyconsulting.com> wrote:
>
> I do have a cover index that includes all of the fields in my view, and PK
> is the leftmost (top) field in the index.  I am thinking that perhaps it
> is
> pulling all of the data from that index and somehow that is causing the
> issue.
>
>