Skip to main content
1 of 3
Racer SQL
  • 7.5k
  • 14
  • 73
  • 136

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

There are queries where when we hit "execute", it shows some rows and it keeps growing, bu the query is not over yet. but sometimes, it waits until the end of the query.

Why does this happen? is there a way to control this?

Racer SQL
  • 7.5k
  • 14
  • 73
  • 136