Viewing 15 posts - 10,231 through 10,245 (of 49,566 total)
Why count(ID), not count(*)?
January 28, 2014 at 4:42 am
Was asking about the specific error that CheckDB found. It says "found 1 errors and repaired 0 errors.", what was that one error?
January 28, 2014 at 4:41 am
crazy_new (1/28/2014)
Not to sure. There are more than 1 records but there are not duplicates.Its just that there can be multiple entries for each address.
Ok, so when an address is...
January 28, 2014 at 4:25 am
What's the query you're running?
January 28, 2014 at 3:32 am
crazy_new (1/28/2014)
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= ,...
January 28, 2014 at 3:30 am
crazy_new (1/28/2014)
Just below that I set the value.SET @ADR3 = (SELECT ADR3
FROM PAT_NAMES_ADDRESS
WHERE ADR1 = @ADDRESS)
SET @ADDRESS = 'M & B Pumps Division'
So search for all rows matching a...
January 28, 2014 at 3:27 am
What was the actual error that CheckDB found?
January 28, 2014 at 3:19 am
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...
January 28, 2014 at 3:17 am
Abu Dina (1/28/2014)
David Webb-CDS (1/27/2014)
21ST CENTURY SERIVES
21ST CENTURY SERVICES
equal, not because they are, but because they SHOULD be. Is...
January 28, 2014 at 1:55 am
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...
January 28, 2014 at 1:04 am
Not following, could you explain more what the problem is?
January 28, 2014 at 12:33 am
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...
January 28, 2014 at 12:32 am
Misbehaving IO subsystems aren't going to honour a read-only flag on a database. Corruption is typically IO subsystem (much rarer memory) related.
January 28, 2014 at 12:31 am
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"
January 27, 2014 at 10:32 pm
Abu Dina (1/27/2014)
Same company same address = duplicate
No company but with same...
January 27, 2014 at 10:30 pm
Viewing 15 posts - 10,231 through 10,245 (of 49,566 total)