Viewing 15 posts - 8,341 through 8,355 (of 8,414 total)
All the answers are in this Books Online entry:
http://technet.microsoft.com/en-us/library/ms175933(SQL.90).aspx
Cheers,
Paul
April 12, 2009 at 12:37 am
With one notable exception, the misinformation in this thread is a bit scary!
Rather than try to write my own mini-article, I would point the interested reader to the excellent TechNet...
April 11, 2009 at 11:50 pm
Hey radek,
I saved that XML as a sql plan and loaded it in SSMS.
:blink: :blink: :blink: :blink: :blink: :blink: :blink:
{mode = glass-half-full}
I think those tables could do with some useful...
April 11, 2009 at 11:15 pm
Jeff Moden (4/11/2009)
...A persisted computed indexed column would do very nicely here.
Hey Jeff,
It would, but an ordinary column would be my first choice, mainly because persisted computed columns are so...
April 11, 2009 at 10:58 pm
Hey everyone and Happy Chocolate Egg Day!
Even later...my 2c:
1. Voting for JOIN too, for all the good reasons already given
2. If the first 3 characters of the zip...
April 11, 2009 at 5:54 pm
Hey Noel,
No worries - I do it all the time, just making sure I wasn't missing something clever...
🙂
Paul
April 7, 2009 at 3:09 pm
JohnG (4/7/2009)
Another good reason to upgrade to SQL...
April 7, 2009 at 3:08 pm
Matt Miller (4/7/2009)
Better?:Whistling:
Ooo! Much!! :smooooth:
Don't work so hard! 🙂
April 7, 2009 at 3:05 pm
GSquared (4/7/2009)
It was, in my opinion, a very strange interview process.
G2, the first guy sounds quite cool, but from the second experience, I would guess you had a lucky escape!...
April 7, 2009 at 3:02 pm
Hey there,
You probably already know, but when you move to SS2K8, check out the new hierarchy id type.
See http://www.sqlservercentral.com/articles/SQL+Server+2008/62204/
Cheers,
Paul
April 7, 2009 at 2:13 am
ssbp2we (4/6/2009)
A: From...
April 6, 2009 at 10:53 pm
Matt Miller (4/6/2009)
With you two posting minor articles for responses, there's no way to adequately quote anything.
Without sarcasm tags or smileys, I'm not sure quite what to make of that...
April 6, 2009 at 6:35 pm
GilaMonster (4/6/2009)
My opinion is that there's a difference between questions for 'extra credit' and questions that result in an immediate fail if the candidate can't answer.
True. This is...
April 6, 2009 at 4:20 pm
Noel,
I am a little confused!
A checksum solution has already been posted.
Binary checksum would be collation and case-sensitive! Not sure that is what the OP wants?
Cheers,
Paul
April 6, 2009 at 3:47 pm
bhushanvinay (4/6/2009)
Any quick examples, for the above one.Regards
Vinay
Hey Vinay,
I think that the contributions so far, and a little googling should enable you to knock something together - learning by doing...
April 6, 2009 at 3:44 pm
Viewing 15 posts - 8,341 through 8,355 (of 8,414 total)