We have a logging database that has been locked down from developer access. The reason it was locked down was because they say that people would run large queries and then leave the results up in Sql Server Management Studio (SSMS).
They read somewhere that doing this leaves the connection open and holds onto memory on the SQL Server.
I had never heard this, but if it is true, then I want to make sure I start closing my queries, especially when I run large ones.
Is it true that leaving a query open in SSMS will hold on to extra memory on the server? If so, is there a way around it?