WhiteLotus (5/26/2015)
GilaMonster (5/26/2015)
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/Thanks for the link . NOTED π
I attach the execution plan .
Project text --> Table A
Below query is clearer I think ( The query that I run ) :
SELECT distinct PT."created_dttm" AS "Created_Datetime",
PT."proj_task_id" AS "Project_Task_Id",
CAST( "text" AS VARCHAR( 2000 ) ) AS "text"
FROM "DB1"."dbo"."Table A" PT
WHERE "code" = 'ABCD'
I donβt think eliminate distinct will make any difference β¦.
That's just a picture and tells us nothing. You need to right click on the actual execution plan, save it as a file, and attach that.
--Jeff Moden
Change is inevitable... Change for the better is not.