Generated using
SQL Data Dictionary
demo version.
Table
Warehouse.ColdRoomTemperatures_Archive
(3,654,736 rows)
Column
Data Type
Identity
Nullable
Default
ColdRoomTemperatureID
bigint
ColdRoomSensorNumber
int
RecordedWhen
datetime2
Temperature
decimal(10,2)
ValidFrom
datetime2
ValidTo
datetime2
Indexes:
ix_ColdRoomTemperatures_Archive
(Clustered)
(< 0.01% Selectivity)
ValidTo
ValidFrom