• It basically means that the statement in question is moving lots of data, either in (writes) or out (reads) of the server. What you do about it really depends on the query in question. You need to understand if it's working as designed, is the design right, are there performance problems, all kinds of stuff. There's no switch or single answer that can help you out. It really depends on the situation, the code, and the structure.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning