Skip to main content
Database Administrators

Return to Question

Minor spelling, start sentence with captital
Source Link
edit approved Apr 13, 2018 at 16:11
TT.
edit approved Apr 13, 2018 at 16:11
TT.
  • 344
  • 1
  • 3
  • 17

Why does SQL Server returnsreturn 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, bubut the query is not over yet. butYet sometimes, it waits until the end of the query.

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

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?

Why does SQL Server return 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, 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?

Tweeted twitter.com/StackDBAs/status/984817497353457665
Adjusting tags since this is SSMS specific-ish and not specific to 2008 R2
Link
LowlyDBA - John M
LowlyDBA - John M
  • 11k
  • 11
  • 45
  • 62
Source Link
Racer SQL
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?