If you have a query window open in SSMS and leave it open, your session stays on the server until the spid is forcibly closed (killed), the user closes out the window, or you physically disconnect your connection to the DB (Connection >> Disconnect or Disconnect All Queries) If you are familiar with Activity Monitor or how to query DMVs for session info, you'll notice these spid's having a status of "sleeping".