Hamid Fathi hamid67fathi
🎯
hamid67fathi
/ ExecutionPlan-Before.xml
Created
December 11, 2016 05:55
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0" encoding="utf-16"?> | |
| <ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.2" Build="12.0.4100.1" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan"> | |
| <BatchSequence> | |
| <Batch> | |
| <Statements> | |
| <StmtSimple StatementCompId="1" StatementEstRows="100" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="120" StatementSubTreeCost="29.3247" StatementText="select top(100)
 Batch_Tasks_Queue.id,
 btq.id
from
 Batch_Tasks_Queue with(nolock)
 inner join Batch_Tasks_Queue btq with(nolock) on Batch_Tasks_Queue.Start_Time < btq.Start_Time
 and btq.Start_Time < Batch_Tasks_Queue.Finish_Time
 and Batch_Tasks_Queue.id <> btq.id 
 and btq.Start_Time is not null
 |
hamid67fathi
/ ExecutionPlan-After.xml
Created
December 11, 2016 05:52
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0" encoding="utf-16"?> | |
| <ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.2" Build="12.0.4100.1" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan"> | |
| <BatchSequence> | |
| <Batch> | |
| <Statements> | |
| <StmtSimple StatementCompId="1" StatementEstRows="100" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="120" StatementSubTreeCost="201.393" StatementText="select top(100)
 Batch_Tasks_Queue.id,
 btq.id,
 Batch_Tasks_Queue.[Parameters], -- this field
 btq.[Parameters] -- and this field
from
 Batch_Tasks_Queue with(nolock)
 inner join Batch_Tasks_Queue btq with(nolock) on Batch_Tasks_Queue.Start_Time < btq.Start_Time
 and btq.Start_Time < Batch_Tasks_Queue.Finish_Time
 and Batch_Tasks_Queue.id <> btq.id |