title: Resource locking in SQL Server Management Studio
body: <p>I've noticed that when viewing query results in a grid in SQL Server Management Studio, it often causes resource locking on the server, preventing other queries from running. Why does this happen, when I'm only opening the table for viewing and not for editing? Disconnecting the query window from the server releases the resources. I assume it doesn't happen when I return the results as text, but I haven't tested this yet.</p>
  
  <p>What is the best practice for using query windows in SSMS?</p>