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...

• This reply was modified 5 years, 8 months ago by pdanes.
• This reply was modified 5 years, 8 months ago by pdanes.
• This reply was modified 5 years, 8 months ago by pdanes.

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...

Ah, thank you. That explains it....

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...

You mean it tries to insert all the rows at once, and only AFTER they are all inserted, does the trigger begin its work?

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...

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...

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...

I also think it's 2008, although it doesn't say that in the properties window. But that's when the machine is from.

That is one of the things I am wondering, if...

• This reply was modified 5 years, 11 months ago by pdanes.

Ah, that looks useful. Thank you.

Good call - that works well. With the index on ID disabled, it is roughly a minute, the same as the original 'bad' version. But with the SSMS-suggested index in...

Grant: "The other is the need to filter after the XML is put together."

Do you mean that it materializes the ENTIRE resultset into one giant XML construct, and then checks...

• This reply was modified 5 years, 12 months ago by pdanes.

I'm still unclear about something, though. Grant, you wrote "...all it takes is a single match and EXISTS stops executing...", which is exactly what I thought EXISTS does, which is...

Thank you both for looking at this. Another spanking for me by SQL Server - what else is new? But it's not going to be that much work to make...

1+ seconds for such a thing is not "quickly" nor resource friendly IMHO

True, one second is not great, but for my purposes, in this application, it was good enough -...