Great! The most powerful deduping algorithm I ever saw.

Nice how-to article. But I wonder why Microsoft does not provide better support for deadlock situations. Hunting SQL server deadlocks is still like in the stone age days of programming...

I had this problem too some time ago. In my case the view was responsible because it seems like views that join linked tables are extremely inefficient. I suspect that...

Besides backup issues maybe something is wrong about your application that lets the transaction log grow too fast. Maybe this article is of some use to you

http://support.microsoft.com/kb/317375/EN-US/

Yeah, I tried to give you an example but I also could not past xml content here.

But as a clue, lookup the SQL Server documentation: there are examples how to...

Really helpful

Concering SQL Server 2005, if I get the documentation right the ignore duplicate key statement has no effect:

"The SQL Server 2005 Database Engine does not allow creating a unique index...

I had this problem too and solved it by row numbering like in the article. Although I had read about the APPLY function it did not come to my mind....

Karl, thank you very much for the explanation, it sounds plausible and I think this is it.

I don't understand the connection of OLE/DB errors with your stored procedure. The stored proc is unaware of OLE/DB. Are you looking for how to handle OLE/DB errors in your...

By chance the disable trigger hint came just when I needed it. Thanks for the nice synopsis you won't find somewhere else.

The function I quoted was actually written by Erland Sommarskog.

My code works fine with it. The website looks interesting.

Thanks again!

Gerhard

Thank you very much, I now use a function I found at

http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/a5e0fdb24323aa13/e0fcc4c2d38883ec%23e0fcc4c2d38883ec

This function can parse very long argument lists, this is why it uses a nested loop....

I would say use transactions in ADO (or any other business logic layer) when you do several consecutive action calls against the database and need to bracket them in one transaction.

Maybe I am completely wrong but when I read "Configuration block version wrong" it looks like there is a wrong version of a .NET assembly, namely the Application Configuration block. I just...