Hi,

Do you have trigger on the target table?

Hi,

You need to install only Integration Services to be able to run the packs from command line or .NET code. Obviously, if you want to deploy the packs to the...

You ave to create SQLConnection object, then SQL Command, configure the SQLCommand object and eventually execute it. There are several methods of execution, varying with the returned results. Please read...

Thanks for sharing this. The trick with sp:CacheMiss is interesting to know.

Piotr

That's a nice question, thanks Ron.

For what it's worth, I remembered that I read about this naming convention in Inside SQL Server 2005 Query Tuning and Optimization. Page 229. 🙂

Also...

Are you sure that you have exactly same schema on this database and others? It maybe that lack of an index on other table triggers scan on the big one....

How does your code populate the temp tables? By the look of your last post would it be a loop or cursor? Please forgive me if I am wrong.

Have you...

Thanks Paul, I didn't see this post before. I really enjoy Craig's posts about execution plans.

Regards

Piotr

I found it might be better to use TOP syntax in the end anyway. The ROWCOUNT setting appears to be not taken into consideration by the query optimizer and this...

Tom, you might also consider adding Execute SQL Task to your package to grab the newsequentialguid() from database instead of using the ExecutionInstanceGuid. It looks like you would need to...

Could you post execution plans for both queries? Have you tried to wrap the query in a stored proc and pass the parameters to it? The sp_executesql overhead is minimal,...

If may I ask, why do you want to run this code in a cursor? It doesn't look like you need to.

Regards

Piotr

Yes, basically you will have rows in inserted and deleted pseudotables for UPDATE, in inserted for INSERT and in deleted only for DELETE.

So you'd have to check something like

if(exists...

Agreed, if it possible, batch the data. You can build an xml fragment and flush it to database at appropriate interval, the performance of your app will gain tremendously.

Regards

Piotr

Would you mind posting actual execution plans for both cases? There is a chance that query optimizer doesn't have enough information (statistics) about the values of dates in the temp...