Viewing 15 posts - 2,926 through 2,940 (of 3,348 total)
Paul White (2/4/2010)
Hi Hugo,You overlooked my post which addressed the 'problem'. It was quite long, so I'm quite shocked that you missed it 😉
Guilty as charged 😉 I...
February 4, 2010 at 6:54 am
Hi Jeff,
As indicated in my previous message, I somehow lost sight of this discussion. Sorry for my sudden disappearance from this topic.
First, thank you for optimizing my alternative running totals...
February 4, 2010 at 1:18 am
Condorman (11/14/2009)
Here in the relevant bit from Hugo's code.
INSERT INTO @Results(AccountID, Date, TransactionDetailID, Amount,
...
February 4, 2010 at 1:03 am
john.arnott (2/3/2010)
The real problem is that REPLICATE uses the same input as output data type, which in this case has an 8000-byte limit, and that longer values are truncated.
I...
February 3, 2010 at 1:07 pm
a hash which treats two different strings as identical is a a serious failure.
No, it's not. Collisions in a hash are by design. After all, the possible number of different...
February 3, 2010 at 12:38 pm
vk-kirov (2/1/2010)
Hugo Kornelis (2/1/2010)
the result of the HASHBYTES algorithm now exceeds 8000 bytes
No, it doesn't 🙂 The SHA-1 algorithm always produces 160-bit output, here is the proof: http://en.wikipedia.org/wiki/SHA#Comparison_of_SHA_functions.
The warning is...
February 1, 2010 at 3:37 am
Nice question. But the explanation is incorrect.
There is no 8000 byte limit on REPLICATE. But there is one on the VARCHAR data type, and since 'A' is considered to be...
February 1, 2010 at 1:39 am
vk-kirov (1/27/2010)
Carlo Romagnano (1/27/2010)
FROM BOL:Including an extremely large number of values (many thousands) in an IN clause can consume resources and return errors 8623 or 8632.
This may happen only...
January 27, 2010 at 2:56 am
If I critisize a QotD, I always try to maintain a positive tone. Especially since, after having submitted some of my own, I know how hard it is to create...
January 27, 2010 at 2:50 am
Thanks, Bitbucket!
And thanks for submitting the QotD as well. I have submitted a few of my own, so I know how much energy goes into it - and how, despite...
January 25, 2010 at 9:20 am
Thanks, Kelsey. You write exactly what I intended to write, but in a much nicer tone.
Bitbucket, if my post came across too harsh, I apologise for the tone.
January 25, 2010 at 9:01 am
bitbucket-25253 (1/25/2010)
Hugo Kornelis
Not a good explanation, though
Ditto for Kelsey Thornton
Did you click on the supporting documentation link to read the full explanation?
Did you read what I actually wrote?
The explanation says...
January 25, 2010 at 8:49 am
Mauve (1/25/2010)
BTW, the code will only run under SQL Server 2008, which wasn't stated. And it will...
January 25, 2010 at 8:30 am
WayneS (1/24/2010)
January 25, 2010 at 12:52 am
Good question.
Not a good explanation, though.
"The constriaints prevent some inserts and deletes from occurring." - I did not run the code, but I am pretty sure that all inserts succeed,...
January 25, 2010 at 12:49 am
Viewing 15 posts - 2,926 through 2,940 (of 3,348 total)