DateTimePartSearch.xml

<?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.1" Build="10.50.1600.1" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementCompId="3" StatementEstRows="1.36364" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" StatementSubTreeCost="0.0326116" StatementText="SELECT bp.Title, bp.CreatedOn FROM BlogPosts bp&#xD;&#xA;WHERE (DATEPART(YEAR, bp.[CreatedOn]) = @year) AND (DATEPART(MONTH, bp.[CreatedOn]) = @month)&#xD;&#xA;ORDER BY bp.CreatedOn;" StatementType="SELECT" QueryHash="0xDE5367C10B7C98B5" QueryPlanHash="0x739E8B342FDAE743">
          <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
          <QueryPlan DegreeOfParallelism="0" MemoryGrant="1024" CachedPlanSize="16" CompileTime="1" CompileCPU="1" CompileMemory="192">
            <RelOp AvgRowSize="321" EstimateCPU="0.000101273" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1.36364" LogicalOp="Sort" NodeId="0" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.0326116">
              <OutputList>
                <ColumnReference Database="[MvcBloggy]" Schema="[dbo]" Table="[BlogPosts]" Alias="[bp]" Column="Title" />
                <ColumnReference Database="[MvcBloggy]" Schema="[dbo]" Table="[BlogPosts]" Alias="[bp]" Column="CreatedOn" />
              </OutputList>
              <MemoryFractions Input="1" Output="1" />
              <RunTimeInformation>
                <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="2" ActualEndOfScans="1" ActualExecutions="1" />
              </RunTimeInformation>
              <Sort Distinct="false">
                <OrderBy>
                  <OrderByColumn Ascending="true">
                    <ColumnReference Database="[MvcBloggy]" Schema="[dbo]" Table="[BlogPosts]" Alias="[bp]" Column="CreatedOn" />
                  </OrderByColumn>
                </OrderBy>
                <RelOp AvgRowSize="321" EstimateCPU="0.0002571" EstimateIO="0.0209028" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1.36364" LogicalOp="Clustered Index Scan" NodeId="2" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0211599" TableCardinality="91">
                  <OutputList>
                    <ColumnReference Database="[MvcBloggy]" Schema="[dbo]" Table="[BlogPosts]" Alias="[bp]" Column="Title" />
                    <ColumnReference Database="[MvcBloggy]" Schema="[dbo]" Table="[BlogPosts]" Alias="[bp]" Column="CreatedOn" />
                  </OutputList>
                  <RunTimeInformation>
                    <RunTimeCountersPerThread Thread="0" ActualRows="2" ActualEndOfScans="1" ActualExecutions="1" />
                  </RunTimeInformation>
                  <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                    <DefinedValues>
                      <DefinedValue>
                        <ColumnReference Database="[MvcBloggy]" Schema="[dbo]" Table="[BlogPosts]" Alias="[bp]" Column="Title" />
                      </DefinedValue>
                      <DefinedValue>
                        <ColumnReference Database="[MvcBloggy]" Schema="[dbo]" Table="[BlogPosts]" Alias="[bp]" Column="CreatedOn" />
                      </DefinedValue>
                    </DefinedValues>
                    <Object Database="[MvcBloggy]" Schema="[dbo]" Table="[BlogPosts]" Index="[PK_BlogPosts]" Alias="[bp]" IndexKind="Clustered" />
                    <Predicate>
                      <ScalarOperator ScalarString="datepart(year,[MvcBloggy].[dbo].[BlogPosts].[CreatedOn] as [bp].[CreatedOn])=[@year] AND datepart(month,[MvcBloggy].[dbo].[BlogPosts].[CreatedOn] as [bp].[CreatedOn])=[@month]">
                        <Logical Operation="AND">
                          <ScalarOperator>
                            <Compare CompareOp="EQ">
                              <ScalarOperator>
                                <Intrinsic FunctionName="datepart">
                                  <ScalarOperator>
                                    <Const ConstValue="(0)" />
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Database="[MvcBloggy]" Schema="[dbo]" Table="[BlogPosts]" Alias="[bp]" Column="CreatedOn" />
                                    </Identifier>
                                  </ScalarOperator>
                                </Intrinsic>
                              </ScalarOperator>
                              <ScalarOperator>
                                <Identifier>
                                  <ColumnReference Column="@year" />
                                </Identifier>
                              </ScalarOperator>
                            </Compare>
                          </ScalarOperator>
                          <ScalarOperator>
                            <Compare CompareOp="EQ">
                              <ScalarOperator>
                                <Intrinsic FunctionName="datepart">
                                  <ScalarOperator>
                                    <Const ConstValue="(2)" />
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Database="[MvcBloggy]" Schema="[dbo]" Table="[BlogPosts]" Alias="[bp]" Column="CreatedOn" />
                                    </Identifier>
                                  </ScalarOperator>
                                </Intrinsic>
                              </ScalarOperator>
                              <ScalarOperator>
                                <Identifier>
                                  <ColumnReference Column="@month" />
                                </Identifier>
                              </ScalarOperator>
                            </Compare>
                          </ScalarOperator>
                        </Logical>
                      </ScalarOperator>
                    </Predicate>
                  </IndexScan>
                </RelOp>
              </Sort>
            </RelOp>
            <ParameterList>
              <ColumnReference Column="@month" ParameterRuntimeValue="(8)" />
              <ColumnReference Column="@year" ParameterRuntimeValue="(2012)" />
            </ParameterList>
          </QueryPlan>
        </StmtSimple>
      </Statements>
    </Batch>
  </BatchSequence>
</ShowPlanXML>