Why count(ID), not count(*)?

Was asking about the specific error that CheckDB found. It says "found 1 errors and repaired 0 errors.", what was that one error?

Ok, so when an address is...

What's the query you're running?

crazy_new (1/28/2014)

---

When I do it before then I get the following error.

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= ,...

So search for all rows matching a...

What was the actual error that CheckDB found?

Where are you setting the value of @ADDRESS?

In your code, you have:

DECLARE @ADR3 VARCHAR(100), @ADDRESS VARCHAR(100)

SET @ADR3 = (SELECT ADR3

FROM PAT_NAMES_ADDRESS

WHERE ADR1 = @ADDRESS)

So you're declaring @ADDRESS then using it...

Abu Dina (1/28/2014)

---

David Webb-CDS (1/27/2014)

---

I'm afraid you're asking for code that would make these two:

21ST CENTURY SERIVES

21ST CENTURY SERVICES

equal, not because they are, but because they SHOULD be. Is...

If you leave max server memory at default, you're telling SQL it can use every scrap of memory on the machine. If that's not what you want (and it usually...

Not following, could you explain more what the problem is?

CPU is the amount of time the query spends actually executing on the CPU(s). Duration is the elapsed time (or datediff start time and end time), this includes time the...

Misbehaving IO subsystems aren't going to honour a read-only flag on a database. Corruption is typically IO subsystem (much rarer memory) related.

Sometimes I wonder if people really want help.

"Sample data please"

"I don't see the point" "It won't be of any benefit"

"Expected results please"

"It's not going to help"

Abu Dina (1/27/2014)

---

It's really about finding duplicate entries within the record set. A duplicate in this case is at site/business level.

Same company same address = duplicate

No company but with same...