My question is simple: What are the differences / similarities / cardinalities between
- Connections and
in SQL Server?
As far as I understand a connection is a single communications channel between a SQL Server instance and a client within which collections of statements grouped as batches are executed. A batch is either implicitly or explicitly mapped to one or several transactions. Is this correct?