transcript for Why does SQL Server return some rows while still executing the query, and sometimes not?