August 25, 2010 at 11:45 am
Steve Jones - Editor (8/25/2010)
Shhh, all this talk about NZ might get my wife talking about making me take her on a plane for 18 hours. Yikes! :w00t:
Just send her, alone, the wrong way... making it a 50 hours flight.
Might make a good argument not to go, or make her a widow, you never know! :hehe:
August 25, 2010 at 11:48 am
She probably would go without me for a month. Guess who gets shovel duty? :hehe:
August 25, 2010 at 11:53 am
Steve Jones - Editor (8/25/2010)
She probably would go without me for a month. Guess who gets shovel duty? :hehe:
You're going to be in that much DooDoo, huh? :w00t:
August 25, 2010 at 12:02 pm
Ray K (8/25/2010)
Steve Jones - Editor (8/25/2010)
Shhh, all this talk about NZ might get my wife talking about making me take her on a plane for 18 hours. Yikes! :w00t:True story: I have a friend who had accumulated so many frequent flier miles that he actually flew to Australia (he lives in California), spent all of one day there, and flew back!
More time in the air than on the ground.
That's sick.
Greg E
August 25, 2010 at 12:08 pm
OP was complaining about PK violation while uploading text file using SSIS.
Someone replied with:
How do you get a PK violation?
Are you inserting the PK values yourself?
Please remind me, again, why we're not allowed to slap someone.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2010 at 12:17 pm
Alvin Ramard (8/25/2010)
OP was complaining about PK violation while uploading text file using SSIS.Someone replied with:
How do you get a PK violation?
Are you inserting the PK values yourself?
Please remind me, again, why we're not allowed to slap someone.
So many people are used to Identity fields being used as PKs that they forget that PKs don't HAVE to be Identity fields. In fact, with the frequency of Ident use, it wouldn't surprise me to find a business that doesn't have PK Clustered Indexes on other columns but the Identity field.
August 25, 2010 at 12:20 pm
Brandie Tarvin (8/25/2010)
Alvin Ramard (8/25/2010)
OP was complaining about PK violation while uploading text file using SSIS.Someone replied with:
How do you get a PK violation?
Are you inserting the PK values yourself?
Please remind me, again, why we're not allowed to slap someone.
So many people are used to Identity fields being used as PKs that they forget that PKs don't HAVE to be Identity fields. In fact, with the frequency of Ident use, it wouldn't surprise me to find a business that doesn't have PK Clustered Indexes on other columns but the Identity field.
It crossed my mind after I posted my comment that he might be confusing PK with Identity.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2010 at 12:21 pm
Brandie Tarvin (8/25/2010)
Alvin Ramard (8/25/2010)
OP was complaining about PK violation while uploading text file using SSIS.Someone replied with:
How do you get a PK violation?
Are you inserting the PK values yourself?
Please remind me, again, why we're not allowed to slap someone.
So many people are used to Identity fields being used as PKs that they forget that PKs don't HAVE to be Identity fields. In fact, with the frequency of Ident use, it wouldn't surprise me to find a business that doesn't have PK Clustered Indexes on other columns but the Identity field.
There are still people out there who really want to use "natural keys" for everything.
They're frequently ints kept somewhere in a spreadsheet.
Also, there are programs that let the program create the id, simulating IDENTITY.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
August 25, 2010 at 12:25 pm
Greg Edwards-268690 (8/25/2010)
Ray K (8/25/2010)
Steve Jones - Editor (8/25/2010)
Shhh, all this talk about NZ might get my wife talking about making me take her on a plane for 18 hours. Yikes! :w00t:True story: I have a friend who had accumulated so many frequent flier miles that he actually flew to Australia (he lives in California), spent all of one day there, and flew back!
More time in the air than on the ground.
That's sick.
FWIW, my friend is a licensed pilot and an aviation buff, so it probably doesn't bother him!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
August 25, 2010 at 1:18 pm
🙁
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2010 at 1:19 pm
[vent]
Worst performance for any web site I've ever been to: https://www.technicalcommunity.com
Guess which big company name is in the upper left hand corner.
Something has to be done about this!!
[/vent]
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2010 at 1:25 pm
Alvin Ramard (8/25/2010)
[vent]Worst performance for any web site I've ever been to: https://www.technicalcommunity.com
Guess which big company name is in the upper left hand corner.
Something has to be done about this!!
[/vent]
Ha!
And this is the "improved" site. Don't forget that.
I went to register my Live account to this and it wouldn't let me. So I created a new account. They spotted it and fixed it. First place I've ever seen do that. Heck, I've still got at least three accounts with PASS (after talking directly to their web geek). So, it's not ALL bad.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 25, 2010 at 1:32 pm
Grant Fritchey (8/25/2010)
Alvin Ramard (8/25/2010)
[vent]Worst performance for any web site I've ever been to: https://www.technicalcommunity.com
Guess which big company name is in the upper left hand corner.
Something has to be done about this!!
[/vent]
Ha!
And this is the "improved" site. Don't forget that.
I went to register my Live account to this and it wouldn't let me. So I created a new account. They spotted it and fixed it. First place I've ever seen do that. Heck, I've still got at least three accounts with PASS (after talking directly to their web geek). So, it's not ALL bad.
I need to extract my PASS Chapter member list for something. Can't do that. It won't work for me.
I need to send out the invitation for tomorrow's .NET user group meeting. Can't do that. I'm not the one that normally does this, but since the others can't log in I was going to give it a try.
Right now, new and improved, you FAIL!
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2010 at 1:41 pm
I don't want to get a contact list out, I want to get a contact list in. Can you do that?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 15 posts - 17,686 through 17,700 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply