Are the posted articles[/url] getting worse?

Ha! Weird typo - not sure how that happened, but I have fixed the post now.

I...

bdba (2/15/2012)

---

Actually I did that, however I am stuck at how to only select the one that are duplicates and not the ones that are not duplicates. The row_number() function...

MERGE (the statement, not the join hint!) is required to be terminated with a semicolon.

Good question.

Good question! What a bizarre restriction.

The updates probably could be compacted quite a bit, but I don't have time right now for a complete rewrite. One thing I would recommend is that you dump...

And another:

DECLARE @data TABLE

(

Code integer NULL,

Name character(1) NULL,

Country nvarchar(50) NULL

);

INSERT @data

...

Another option:

DECLARE @data TABLE

(

Code integer NULL,

Name character(1) NULL,

Country nvarchar(50) NULL

);

INSERT @data

...

kschwid (2/13/2012)

---

I also stated before that I only use them for reporting, so there are no inserts or updates involved, using NoLock on some of the tables in my query...

GSquared (2/13/2012)

---

On the original question, Select takes a "shared lock", meaning multiple Selects can run on the same rows at the same time and won't block each other. No...

One of the conditions for...

tripri (2/13/2012)

---

After reach to 20k or more the average duration is going up to 450 ms and some of the child tables are having index scans which used to have...

SELECT

ItemNum,

Category =

'Group' + CHAR(64 +

...

You can make the process more efficient still by using minimally-logged operations rather than the fully-logged DELETE statement:

CREATE...