• whats the wait type when you are running the select?

    can you do select top 100

    are you doing this from the server, or from a client?