Viewing 15 posts - 316 through 330 (of 458 total)
Duncan, nice follow-up to your last question. I'm gratified? relieved? to see so many wrong answers, as I thought everyone else but me knew what Tibor Karaszi pointed out...
April 13, 2011 at 10:08 am
Maybe I'm a bit late here, but I'll mention that I prefer to use SET over SELECT when assigning variable values that are fixed (and not the results of a...
April 11, 2011 at 6:59 am
Peter Trast (4/10/2011)
Is anyone still reading this post down to page 11? 😀
No.
😉
Rich
April 10, 2011 at 5:28 pm
Was this a trick question designed to simulate the, ah, "impedance mismatch" between, say, developers and DBAs? (*sings* "You say NCHAR, I say NVARCHAR, let's call the whole thing...
April 8, 2011 at 6:09 am
Jeff Moden (4/7/2011)
Haven't seen that actually work before without the use of the ol' FORCEORDER option. And, no... I don't use that option.
Well, if I've stumped The Mighty Jeff,...
April 7, 2011 at 5:15 pm
Thanks all for your help. I've fixed the problem and discovered something truly odd (to me anyway). Can someone explain this?
I followed up on Craig's comment "Your nested...
April 7, 2011 at 9:08 am
GSquared (4/6/2011)
I may be missing it, but I don't see all the index definitions that are being used in the execution plans.
Sorry, GSquared, in my effort to simplify and make...
April 6, 2011 at 5:18 pm
GSquared (4/6/2011)
April 6, 2011 at 2:02 pm
Peter Trast (4/6/2011)
crookj (4/6/2011)
Ray K (4/6/2011)
Peter Trast (4/6/2011)
SplendiferousVociferous
Bendiferous
Joe
Ferrous
Wheel
Rich
April 6, 2011 at 1:15 pm
Craig Farrell (4/6/2011)
April 6, 2011 at 1:12 pm
Duncan Pryde (4/6/2011)
I was motivated to come up with the question after following a discussion relating to...
April 6, 2011 at 9:28 am
I had always used the ANSI syntax thinking it was multilanguage, only to discover later that it wasn't. The reason I'd never noticed is probably that almost all our servers...
March 28, 2011 at 7:22 am
I had always used the ANSI syntax thinking it was multilanguage, only to discover later that it wasn't. The reason I'd never noticed is probably that almost all our servers...
March 28, 2011 at 7:11 am
Duncan Pryde (3/28/2011)
rmechaber (3/28/2011)
I'd still like to see someone try this out on a SQL 2000 box:
SET LANGUAGE britishSELECT CAST('2003-02-28' AS datetime)
Similar error: "The conversion of a char data type...
March 28, 2011 at 6:31 am
Viewing 15 posts - 316 through 330 (of 458 total)