Viewing 15 posts - 8,341 through 8,355 (of 8,416 total)
Hey greggoble2,
I've used QV a fair bit. I would encourage you to download the free trial and experiment. Your question is just a little to broad to reply...
April 12, 2009 at 1:00 am
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
Viewing 15 posts - 8,341 through 8,355 (of 8,416 total)