Viewing 15 posts - 2,236 through 2,250 (of 3,348 total)
Peter Trast (2/7/2012)
I cannot think of a real world example right now where this would make sense.
Real-world examples are easy enough to find. For instance, the current balance of an...
February 7, 2012 at 12:20 pm
GilaMonster (2/6/2012)
Is it bad form, if you create a QotD, to list your own article as a reference?
If it's a good article? No, not at all. I've done it in...
February 6, 2012 at 8:41 am
Stephen.Rice (2/6/2012)
MIN(ABS(SIGN(num))) * (1-(SUM(SIGN(num) * (SIGN(num) -1))%4)) * POWER(10.,SUM(LOG10(ABS(Num) + 1...
February 6, 2012 at 4:13 am
SQL Kiwi (2/6/2012)
We use a CLR aggregate for this.
That's definitely cleaner, and easier to understand code. But how does the performance of a CLR aggregate compare to performance of a...
February 6, 2012 at 4:05 am
archie flockhart (2/6/2012)
February 6, 2012 at 4:02 am
Stewart "Arturius" Campbell (2/6/2012)
vk-kirov (2/6/2012)
Hugo Kornelis (2/6/2012)
And 34% of them are for "you can never rollback a truncate table statement"Maybe they are Oracle refugees? :hehe: http://www.sqlservercentral.com/articles/Raw+Materials/71108/
A TRUNCATE can be rolled...
February 6, 2012 at 1:37 am
I wanted to comment that this question is superfluous, that everyone knows this. But.....
At the time of writing:
"Incorrect answers: 56% (52)"
And 34% of them are for "you can never rollback...
February 6, 2012 at 1:13 am
I just saw the answer by Mike. I like the more compact way to get the multiplication factor (CHECKSUM_AGG), but I'm also a bit concerned - I could not find...
February 6, 2012 at 1:08 am
The method in the article is only good for positive (>0) values. Here is a formula that works for zeroes and negatives as well:
COALESCE(EXP(SUM(LOG(ABS(NULLIF(val, 0))))),0) * (1 - 2 *...
February 6, 2012 at 1:02 am
L' Eomot Inversé (2/3/2012)
so what is the correct case mixture? Presumably "geometry" going by Hugo's note, which seems to make SQL Server's type naming a bit inconsistent.
Yep, "geometry" (all lowercase)...
February 3, 2012 at 12:01 pm
And this, dear friends, is why everyone working with SQL Server should be forced to do all development and testing on an instance and in databases with a case-sensitive collation.
SELECT...
February 3, 2012 at 3:46 am
cfradenburg (2/2/2012)
zerko (2/1/2012)
OK now I'm really confused
I'm guessing you didn't read the thread. Any time there's something wrong in the question it gets discussed thoroughly. If you read...
February 2, 2012 at 4:33 am
L' Eomot Inversé (1/31/2012)
So bitbucket has not asked the question he meant to ask, but a different (and easier) question: "can a persisted columns support foreign key constraints?".
:laugh:
Just...
January 31, 2012 at 5:51 am
Meh, I don't like questions where people who really understand the subject have a 50/50 chance of getting it right because they have to second-guess the author's intention.
"Is this a...
January 31, 2012 at 12:53 am
I knew I'd probably get this wrong, as I know very little about XML, and I'm not actively seeking to change that. But from what I picked up over time...
January 27, 2012 at 1:40 am
Viewing 15 posts - 2,236 through 2,250 (of 3,348 total)