An hour for 30k records?  Obviously, that's not good... I'm thinking that the ORDER BY is what is really slowing things down but I could be wrong... the UNIQUE IGNORE DUPLICATE...

That's one of the things I admire about you, Remi... absolute integrity and honesty...

Here's a couple of links I was involved with that explain it all...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=243646&p=2

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=1073&lngWId=5

Absolutely correct, Remi... you and I both know that "open text" columns that contain multiple pieces of data (city,state... full name, etc) are the absolute worst and will usually require...

It means the deadlock occurred on an Index level rather than a table or a page...

You don't need dynamic SQL for this...

drop table #test

CREATE TABLE #Test( FieldOne varchar(10),

                                   FieldTwo integer)

DECLARE @Parameter1 integer

SET @Parameter1 = 1

INSERT INTO #Test

SELECT 'Test...

There's several ways to do this... here's one if you have SA privs... there are other methods if this one doesn't suit ya... let us know...

DECLARE @Cmd VARCHAR(8000)

SET @Cmd =...

Are you talking about having SQL Server send email?

Naga's update is good and nasty fast... it just needs a filter...

update Customer

set address = LEFT (address, LEN(address) - CHARINDEX(',', REVERSE(address)))

WHERE LEN(Address) - LEN(REPLACE(Address,',','')) = 2

Don't forget that ISNUMERIC sometimes allows an "e" or "d" and will also allow decimal points and dollar signs and etc, etc....

The method Ken uses is nasty fast and is...

First of all, you shouldn't be inserting "Owner" into the Audits table because that's a form of denormalization you don't need here... bit, if you insist, here's a self supporting...

Good tool... bad answer ... you still haven't answered the "generic" question.  David got it, though...

(and it appears that you are not paying for this form of advertising which might...

 SELECT i.*

   FROM IndSales i

   LEFT OUTER JOIN mstBranch b

                ON i.BankCode   = b.BankCode

               AND i.BranchCode = b.BranchCode

  WHERE b.BankCode IS NULL

Try running the SELECT portion by itself... if the performance is similar to the performance of the whole INSERT/SELECT, then you might try using the INDEX TUNING WIZARD (and a...

Just for grins...

DECLARE @Num1 FLOAT

DECLARE @Num2 FLOAT

    SET @Num1 = -1.2

    SET @Num2 = -3.4

 SELECT Largest = (ABS(Num2-Num1)+(Num2+Num1))/2

Dunno if this is what you are looking for... and I haven't tested it 'cause I'm on vacation with no access to SQL...

declare @recipe table (recipeID numeric(18,0) NOT NULL)

insert...