gdoddsy

UPDATE	AggregateTest
SET	LastUsedDateTime = MAX(recordedTime)
FROM	SFOGateInfo

gdoddsy

WITH AggregateData AS
(
	SELECT	Gate
		,MAX(RecordedTime) AS MaxRecordedTime
	FROM	dbo.SFOGateInfo
)
UPDATE		AggregateTest
SET		LastUsedDateTime = AggregateData.MaxRecordedTime
FROM		AggregateTest
INNER JOIN	AggregateData

gdoddsy

EXEC sp_blitzwho @ExpertMode = 1

gdoddsy

ALTER DATABASE StackOverflow
SET READ_COMMITTED_SNAPSHOT ON

gdoddsy

CREATE TABLE Department
(
	DeptID		  INT		  NOT NULL PRIMARY KEY CLUSTERED
	,DeptName	  VARCHAR(50) NOT NULL
	,ManagerID	  INT		  NULL
	,SysStartTime DATETIME2	  GENERATED ALWAYS AS ROW START NOT NULL
	,SysEndTime	  DATETIME2	  GENERATED ALWAYS AS ROW END NOT NULL
	,PERIOD FOR SYSTEM_TIME(SysStartTime, SysEndTime)
)
WITH (SYSTEM_VERSIONING = ON)

gdoddsy

UPDATE dbo.Department
SET DeptName = 'Sales and Marketing'

UPDATE dbo.Manager
SET ManagerName = 'Greg Dodd'

gdoddsy

RAISERROR ('Test', 0, 1) WITH NOWAIT