I have this code:
select LastReqTime,
BlockedOn,
UncommitOps
from sa_conn_info()
WHERE LastReqTime < DATEADD(mi,-60,GETDATE()) AND BlockedOn > 0 AND UncommitOps = 0
An example of the return is:
Is there a way to instruct SQL to return and show all values, without limiting the display? In the above
query, it shows the first 115 rows and I must manually sort or scroll down to see the total number.
Also is there a way to get a count of each unique BlockedOn value, for use in a different query?