The DAC port is assigned dynamically by SQL Server during startup. When connecting to the default instance, the DAC avoids using a SQL Server Resolution Protocol (SSRP) request to the...

CREATE TABLE t(id INT IDENTITY, i INT)

BEGIN TRAN

INSERT INTO t VALUES (4),(2),(3)

SELECT * FROM t

ROLLBACK TRAN

SELECT * FROM t

INSERT INTO t VALUES (4),(2),(3)

SELECT * FROM t

where is rollback?

DECLARE @t TABLE (id INT)

SELECT SUM(1) AS sum_, COUNT(*) AS cnt_ FROM @t

sum_=NULL

cnt_=0

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/c75d0d4b-4008-4e71-9a9d-cee2a566bd3b.htm

The pages in an encrypted database are encrypted before they are written to disk and decrypted when read into memory