gdoddsy

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

gdoddsy

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

UPDATE dbo.Manager
SET ManagerName = 'Greg Dodd'

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

ALTER DATABASE StackOverflow
SET READ_COMMITTED_SNAPSHOT ON

gdoddsy

EXEC sp_blitzwho @ExpertMode = 1

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

INSERT INTO 	AggregateTest (Gate, LastUsedDateTime)
SELECT		Gate
		MAX(RecordedTime)
FROM		SFOGateInfo
GROUP BY	Gate

gdoddsy

UPDATE	AggregateTest
SET	LastUsedDateTime = MAX(recordedTime)
FROM	SFOGateInfo

gdoddsy

CREATE TABLE AggregateTest
(
	ID				  INT		   IDENTITY(1, 1) PRIMARY KEY NOT NULL
	,Gate			  VARCHAR(5)   NULL
	,LastUsedDateTime DATETIME2(7) NULL
)

gdoddsy

DBCC TRACEON(460)