SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT *
INTO   #temp
FROM   sys.objects
6 rows affected

CREATE CLUSTERED INDEX ix
  ON #temp(type, modify_Date DESC)
set statistics xml on;SELECT TOP 1 WITH TIES *
FROM   #temp
ORDER  BY ROW_NUMBER()
            OVER(
              PARTITION BY type
              ORDER BY modify_Date DESC);


name
object_id
principal_id
schema_id
parent_object_id
type
type_desc
create_date
modify_date
is_ms_shipped
is_published
is_schema_published


queue_messages_2009058193
2025058250
null
4
2009058193
IT
INTERNAL_TABLE
13/04/2009 12:59:13
22/08/2017 19:38:04
True
False
False

EventNotificationErrorsQueue
2009058193
null
1
0
SQ
SERVICE_QUEUE
13/04/2009 12:59:13
13/04/2009 12:59:13
True
False
False




Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.8" Build="14.0.3015.40"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT TOP 1 WITH TIES *&#xd;&#xa;FROM   #temp&#xd;&#xa;ORDER  BY ROW_NUMBER()&#xd;&#xa;            OVER(&#xd;&#xa;              PARTITION BY type&#xd;&#xa;              ORDER BY modify_Date DESC)" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.0146755" StatementEstRows="6" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x3432B8302F05BEE5" QueryPlanHash="0x087BEB3ED766FBD6" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="140"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" MemoryGrant="1024" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="32" CompileTime="0" CompileCPU="0" CompileMemory="160"><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544" RequiredMemory="512" DesiredMemory="544" RequestedMemory="1024" GrantWaitTime="0" GrantedMemory="1024" MaxUsedMemory="16" MaxQueryMemory="605728"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="419378" EstimatedPagesCached="26211" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2170256"></OptimizerHardwareDependentProperties><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Top" LogicalOp="Top" EstimateRows="6" EstimateIO="0" EstimateCPU="6e-007" AvgRowSize="237" EstimatedTotalSubtreeCost="0.0146755" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="name"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="object_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="principal_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="schema_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="parent_object_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type_desc"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="create_date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="modify_date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_ms_shipped"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_published"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_schema_published"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Top RowCount="0" IsPercent="0" WithTies="1"><TieColumns><ColumnReference Column="Expr1003"></ColumnReference></TieColumns><TopExpression><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></TopExpression><RelOp NodeId="1" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="6" EstimateIO="0.0112613" EstimateCPU="0.00012444" AvgRowSize="245" EstimatedTotalSubtreeCost="0.0146749" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="name"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="object_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="principal_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="schema_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="parent_object_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type_desc"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="create_date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="modify_date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_ms_shipped"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_published"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_schema_published"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="1" InputMemoryGrant="1024" OutputMemoryGrant="640" UsedMemoryGrant="16"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Column="Expr1003"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="2" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="6" EstimateIO="0" EstimateCPU="4.8e-007" AvgRowSize="245" EstimatedTotalSubtreeCost="0.0032892" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="name"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="object_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="principal_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="schema_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="parent_object_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type_desc"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="create_date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="modify_date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_ms_shipped"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_published"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_schema_published"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"></Sequence></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="3" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="6" EstimateIO="0" EstimateCPU="1.2e-007" AvgRowSize="245" EstimatedTotalSubtreeCost="0.00328872" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="name"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="object_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="principal_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="schema_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="parent_object_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type_desc"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="create_date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="modify_date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_ms_shipped"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_published"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_schema_published"></ColumnReference><ColumnReference Column="Segment1004"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1004"></ColumnReference></SegmentColumn><RelOp NodeId="4" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="6" EstimatedRowsRead="6" EstimateIO="0.003125" EstimateCPU="0.0001636" AvgRowSize="237" EstimatedTotalSubtreeCost="0.0032886" TableCardinality="6" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="name"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="object_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="principal_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="schema_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="parent_object_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type_desc"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="create_date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="modify_date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_ms_shipped"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_published"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_schema_published"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="6" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="object_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="principal_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="schema_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="parent_object_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type_desc"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="create_date"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="modify_date"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_ms_shipped"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_published"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_schema_published"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Index="[ix]" IndexKind="Clustered" Storage="RowStore"></Object></IndexScan></RelOp></Segment></RelOp></SequenceProject></RelOp></Sort></RelOp></Top></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>


set statistics xml on;WITH T
     AS (SELECT *,
                ROW_NUMBER()
                  OVER(
                    PARTITION BY type
                    ORDER BY modify_Date DESC) AS rn
         FROM   #temp)
SELECT *
FROM   T
WHERE  rn = 1
ORDER  BY type,
          modify_Date DESC;


name
object_id
principal_id
schema_id
parent_object_id
type
type_desc
create_date
modify_date
is_ms_shipped
is_published
is_schema_published
rn


queue_messages_2009058193
2025058250
null
4
2009058193
IT
INTERNAL_TABLE
13/04/2009 12:59:13
22/08/2017 19:38:04
True
False
False
1

EventNotificationErrorsQueue
2009058193
null
1
0
SQ
SERVICE_QUEUE
13/04/2009 12:59:13
13/04/2009 12:59:13
True
False
False
1




Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.8" Build="14.0.3015.40"><BatchSequence><Batch><Statements><StmtSimple StatementText="WITH T&#xd;&#xa;     AS (SELECT *,&#xd;&#xa;                ROW_NUMBER()&#xd;&#xa;                  OVER(&#xd;&#xa;                    PARTITION BY type&#xd;&#xa;                    ORDER BY modify_Date DESC) AS rn&#xd;&#xa;         FROM   #temp)&#xd;&#xa;SELECT *&#xd;&#xa;FROM   T&#xd;&#xa;WHERE  rn = 1&#xd;&#xa;ORDER  BY type,&#xd;&#xa;          modify_Date DESC" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.00329208" StatementEstRows="6" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x5BE12BD84022211B" QueryPlanHash="0xDA93E27180453795" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="140"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="32" CompileTime="0" CompileCPU="0" CompileMemory="208"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="419378" EstimatedPagesCached="26211" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2170256"></OptimizerHardwareDependentProperties><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="6" EstimateIO="0" EstimateCPU="2.88e-006" AvgRowSize="245" EstimatedTotalSubtreeCost="0.00329208" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="name"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="object_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="principal_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="schema_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="parent_object_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type_desc"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="create_date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="modify_date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_ms_shipped"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_published"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_schema_published"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="1" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="6" EstimateIO="0" EstimateCPU="4.8e-007" AvgRowSize="245" EstimatedTotalSubtreeCost="0.0032892" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="name"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="object_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="principal_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="schema_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="parent_object_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type_desc"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="create_date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="modify_date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_ms_shipped"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_published"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_schema_published"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"></Sequence></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="6" EstimateIO="0" EstimateCPU="1.2e-007" AvgRowSize="245" EstimatedTotalSubtreeCost="0.00328872" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="name"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="object_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="principal_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="schema_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="parent_object_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type_desc"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="create_date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="modify_date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_ms_shipped"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_published"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_schema_published"></ColumnReference><ColumnReference Column="Segment1004"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1004"></ColumnReference></SegmentColumn><RelOp NodeId="3" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="6" EstimatedRowsRead="6" EstimateIO="0.003125" EstimateCPU="0.0001636" AvgRowSize="237" EstimatedTotalSubtreeCost="0.0032886" TableCardinality="6" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="name"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="object_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="principal_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="schema_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="parent_object_id"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type_desc"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="create_date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="modify_date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_ms_shipped"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_published"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_schema_published"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="6" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="object_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="principal_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="schema_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="parent_object_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="type_desc"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="create_date"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="modify_date"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_ms_shipped"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_published"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Column="is_schema_published"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Schema="[dbo]" Table="[#temp]" Index="[ix]" IndexKind="Clustered" Storage="RowStore"></Object></IndexScan></RelOp></Segment></RelOp></SequenceProject></RelOp><Predicate><ScalarOperator ScalarString="[Expr1003]=(1)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1003"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
name	object_id	principal_id	schema_id	parent_object_id	type	type_desc	create_date	modify_date	is_ms_shipped	is_published	is_schema_published
queue_messages_2009058193	2025058250	null	4	2009058193	IT	INTERNAL_TABLE	13/04/2009 12:59:13	22/08/2017 19:38:04	True	False	False
EventNotificationErrorsQueue	2009058193	null	1	0	SQ	SERVICE_QUEUE	13/04/2009 12:59:13	13/04/2009 12:59:13	True	False	False