Microsoft SQL Server MVP Denny Cherry breaks down multiple ways on how to troubleshoot a type -2 blocking session ID error. When we look at sessions being blocked in ...

While of course it will be kept inside a continuing session #+begin_src sql-session :var path="test" :session PG :results table set search_path to $path, public; show ...

SELECT s.session_id, r.request_id, request_start_time= r.start_time, s.login_time, s.login_name, s.client_interface_name, session_status = s.status, request_status= r ...

Using session is fragile, it's non-scalable both on the client (meaning the user can no longer use multiple tabs to parallelize processes) and on the server (for obvious reasons), and it fools you ...