Viewing 15 posts - 2,071 through 2,085 (of 3,348 total)
paul.knibbs (7/11/2012)
Slightly odd behaviour from nchar() there, I learned something...
Hmmm, not sure why you this is strange behaviour for nchar. It is fixed length, so any shorter length string put...
July 11, 2012 at 3:05 am
GilaMonster (7/9/2012)
It's why I never write QotD any longer.
And that is really a loss. I can understand yoour feelings. Sometimes, the comments are fair. Sometimes, they are far-fetched. And sometimes,...
July 9, 2012 at 7:54 am
GPO (7/5/2012)
July 5, 2012 at 1:34 pm
Steve Cullen (7/5/2012)
This must be one of those Monty Python type questions:
Q: What is your name?
A: Steve Cullen
Q: What is your quest?
A: I seek knowledge and...
July 5, 2012 at 1:29 pm
Andrew Diniz (7/3/2012)
On a serious note, where is a view's meta-data kept and under what circumstances might a view return inconsistent results as a result of base table schema changes?
The...
July 3, 2012 at 4:10 am
It's a bit disappointing that nobody has yet commented that the "best" way to deal with the issue is to drop the view, then create a new one that does...
July 3, 2012 at 1:12 am
roger.plowman (6/28/2012)
While I'm late to the party and missed answering yesterday 🙂 I knew foreign keys don't generate indexes, but my question is why the heck not?
Maybe because they often...
June 28, 2012 at 2:47 pm
chriscoates (6/28/2012)
INERSECT returns "those distinct values that are common between tables"
I have never seen a situation where:
SELECT DISTINCT a.x
FROM a
INNER...
June 28, 2012 at 2:38 pm
chriscoates (6/27/2012)
June 27, 2012 at 4:35 pm
Sorry for my lack of replies. I am currently attending the TechEd Europe conference in Amsterdam, so I have very little time for other stuff.
I don't have time to address...
June 27, 2012 at 4:31 pm
subrammail (6/27/2012)
June 27, 2012 at 4:23 pm
I know about NULLIF, so I should have gotten it right. But the presence of the (unused) column X in the table confused me; I kept checking answers as if...
June 26, 2012 at 3:05 pm
chriscoates (6/26/2012)
Prior to answering I would have done something like
SELECT DISTINCT x AS 'Intersect Chars with BIGINT'
FROM #A
INNER JOIN #B on #b.M = #a.x
A quick execution plan...
June 26, 2012 at 2:58 pm
dineshbabus (6/25/2012)
Thanks Man.Can u tell me what will be default mode of "XACT_ABORT" in sql server. If i'm setting it as ON then how long it will be effective.
The...
June 26, 2012 at 2:56 pm
Revenant (6/25/2012)
Hugo Kornelis (6/25/2012)
Neither table variables not temporary tables are created in memory only. And both are created in memory only. . . .
Hugo, hat off.
When we happen to be...
June 25, 2012 at 2:39 pm
Viewing 15 posts - 2,071 through 2,085 (of 3,348 total)