Viewing 15 posts - 3,256 through 3,270 (of 8,416 total)
Arto,
I do vaguely remember something like this being a bug - I'll see if I can track the Connect item down.
In any case, it seems fixed in the latest 2005...
May 27, 2010 at 11:04 pm
This is largely a question of personal preference and formatting.
Specifying table constraints may make the definition easier to maintain in some circumstances; whereas column constraints may seem 'closer' to the...
May 27, 2010 at 10:37 pm
Jeff Moden (5/27/2010)
BWAA-HAAA!!! You certainly ARE paranoid! I was talking about me avoiding people hence the irony of not being alone in the thought. :hehe:
Yeah I know 😀
Just...
May 27, 2010 at 10:11 pm
Jeff Moden (5/27/2010)
jcrawf02 (5/27/2010)
Paul White NZ (5/27/2010)
Note to self: avoid PeopleSoft.You have four too many letters on the end there.
Heh... ironicly, I'm glad to see I'm not alone in that....
May 27, 2010 at 9:05 pm
WayneS (5/27/2010)
Paul White NZ (5/27/2010)
Well unless it really upsets you, I'd like to decide where to spend those dollars 😛
So, if it does upset me, then you'll go ahead and...
May 27, 2010 at 9:03 pm
Hugo Kornelis (5/27/2010)
Or, another way to put it, you are missing that the point of these questions is to think about it, not to test your ability to copy/paste.
Firm but...
May 27, 2010 at 8:56 pm
Jeff Moden (5/27/2010)
That's the only excuse I have for not seeing this article until today and I'm sticking to it. 😛
I know this isn't as funny as I think it...
May 27, 2010 at 8:55 pm
Wise words Mr Moden (as usual). I did find that post arrogant and rude, but so much so it was almost funny (maybe that's just me though).
It (normally) takes...
May 27, 2010 at 8:53 pm
WayneS (5/27/2010)
It is stated in BOL:
Instead of constructing a B-tree structure based on a value stored in a particular row, the Full-Text Engine builds an inverted, stacked,...
May 27, 2010 at 8:46 pm
Note to self: avoid PeopleSoft.
May 27, 2010 at 11:15 am
jts_2003 (5/27/2010)
http://msdn.microsoft.com/en-us/library/ms175049.aspx
This clearly gives 8, which wasbn't even an option!
Not my favourite question, although it did make me think a bit more about indexes I...
May 27, 2010 at 10:33 am
Jack Corbett (5/27/2010)
I should have quoted Steve's post asking if anyone's used it.
Oh, right, gotcha 🙂
Yes, for an interview answer cascading deletes with SET NULL would be the best answer....
May 27, 2010 at 9:30 am
Luke L (5/27/2010)
May 27, 2010 at 9:22 am
Jack Corbett (5/27/2010)
May 27, 2010 at 9:19 am
Viewing 15 posts - 3,256 through 3,270 (of 8,416 total)