Viewing 15 posts - 121 through 135 (of 465 total)
There is no difference in the execution plan. Just the number of rows estimated.
I found this in the second plan and not in the first. Interestingly, the second plan...
January 13, 2020 at 7:51 pm
Think of "Left Join" as a different operator from "Inner Join". That is why SQL Server is needing to generate a different plan. Unless you put in parentheses to...
January 13, 2020 at 7:31 pm
Okay, that didn't take. Here is a zipped version.
January 13, 2020 at 6:00 pm
I also swapped the order of the two queries and ran them again. I both cases, the query first in execution order took more time than the second. Here is...
January 13, 2020 at 5:26 pm
If you run the queries with
SET STATISTICS IO, TIME ONIs there any difference in the results? If so can you paste them in here?
SQL Server parse...
January 13, 2020 at 5:22 pm
I think the order of operations regarding the left join is coming into play here. The optimizer is leaving the door open to the join between P and T...
January 13, 2020 at 4:52 pm
I don't think it should make any difference, as the optimiser will/should work out the best order to execute the joins. So both queries should have the same execution...
January 13, 2020 at 4:49 pm
I did the bit of disabling and re-enabling the trigger, but still had problems with the text getting populated correctly. I then discovered a bug in my trigger. The condition...
October 30, 2019 at 8:54 pm
You mean it tries to insert all the rows at once, and only AFTER they are all inserted, does the trigger begin its work?
Yes.
Ah, thank you. That explains it....
October 30, 2019 at 11:22 am
I wonder if maybe it would be more effective to disable the index on this field, do the import and then re-enable the index. Under normal conditions, only one record...
October 30, 2019 at 10:36 am
You mean it tries to insert all the rows at once, and only AFTER they are all inserted, does the trigger begin its work?
October 30, 2019 at 10:06 am
That's what the trigger is supposed to do - on insert, it fills in the CompleteTaxonText column. And it does, when I insert manually, or loop through the insert recordset...
October 30, 2019 at 9:29 am
Thank you for the thoughts. I am not the only user - if I was, I would just leave it. I am the only developer/DBA. The system has around ten...
October 10, 2019 at 6:04 pm
Operacní systém Microsoft® Windows Server® 2008 Standard
Verze 6.0.6003 Service Pack 2 Sestavení 6003
Další popis systému Není k dispozici
Výrobce systému Microsoft Corporation
Název systému PALEO-SERVER
Výrobce systému HP
Model systému ProLiant ML350 G5
Typ systému...
October 7, 2019 at 9:09 pm
Viewing 15 posts - 121 through 135 (of 465 total)