There are queries where when we hit "execute", it shows some rows and it keeps growing, but the query is not over yet. Yet sometimes, it waits until the end of the query.
Why does this happen? Is there a way to control this?
Why does SQL Server return some rows while still executing the query, and sometimes not?
Racer SQL
- 7.5k
- 14
- 73
- 136