WHERE IN is not normally an acceptable substitute for a good old fashioned inner join or equi join and tends to be a bit slower.  WHERE NOT IN, however, has...

While Steve's post may have been pushing the boundaries a little Jeff, I still appreciate his response.

If you're...

Not sure how I'd pose the question in such a manner to see how many DBAs could get the answer right without using QA... any ideas?

If you wish to delve into semantics, I suppose you are correct. Still, you didn't meet the spirit of the original posting nor have any of the 23 posts you've...

In order to use non-local UNC's, the server services must start with a windows login that has access to the UNC's desired.  Our DBA's setup a special "SQLDBA" user (with...

Sreejith,

Good code but if you run it more than once, it inserts additional new "Expired" records for the same ticket(s) that already have "Expired" records... you forgot to check to...

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