July 11, 2013 at 4:13 pm
Chad Crawford (7/11/2013)
Koen Verbeeck (7/11/2013)
Anyone have an idea what's wrong with this guy's SQL Agent?http://www.sqlservercentral.com/Forums/Topic1471588-1292-1.aspx#bm1472553
There's a man who leads a life of danger. To everyone he meets he stays a stranger. Oops... wrong agent, never mind.
With every move he makes, another chance he takes. Odds are he won't be employed tomorrow. 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 11, 2013 at 5:54 pm
Chad Crawford (7/11/2013)
Koen Verbeeck (7/11/2013)
Anyone have an idea what's wrong with this guy's SQL Agent?http://www.sqlservercentral.com/Forums/Topic1471588-1292-1.aspx#bm1472553
There's a man who leads a life of danger. To everyone he meets he stays a stranger. Oops... wrong agent, never mind.
Perhaps he's gone to live in a strange land and has his pistol in his hand> If so, 'the agent may be defective because he has been playing too much alcoholic chess - or is that the wrong agent too?
Tom
July 11, 2013 at 6:24 pm
Sean Lange (7/11/2013)
OK I will show my true American colors here. My wife's company just got a new client in Newfoundland. She is going to have to travel there this fall at some point and wants to take me with her. This sounds like a great opportunity. Then the realization that I don't have a passport hits me. This is probably unbelievable to many of you that a guy in his mid 40s doesn't have a passport. The US is a big place and I used to able to go to Canada and Mexico with no passport. The last time I truly traveled abroad was the summer I spent in England when I was 10. That means my passport expired more than 25 years ago. 😀 There are a lot of extra hoops to jump through because I have not had a passport for so long. It would actually be easier if I had never had one before. The upside is that if it comes through in time I should be able to spend a week in Vancouver in September too since she has some client meetings there.
I read a few years back that less than 10% of Americans have a passport, so if it helps you're not alone.
The State Department used to have an expedited passport issuance service, but that was also quite a while back.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
July 11, 2013 at 7:26 pm
I renewed my passport last year. There still was expedited service, but I didn't choose it. Got mine in under 4 weeks.
July 11, 2013 at 7:32 pm
dwain.c (7/11/2013)
Sean Lange (7/11/2013)
OK I will show my true American colors here. My wife's company just got a new client in Newfoundland. She is going to have to travel there this fall at some point and wants to take me with her. This sounds like a great opportunity. Then the realization that I don't have a passport hits me. This is probably unbelievable to many of you that a guy in his mid 40s doesn't have a passport. The US is a big place and I used to able to go to Canada and Mexico with no passport. The last time I truly traveled abroad was the summer I spent in England when I was 10. That means my passport expired more than 25 years ago. 😀 There are a lot of extra hoops to jump through because I have not had a passport for so long. It would actually be easier if I had never had one before. The upside is that if it comes through in time I should be able to spend a week in Vancouver in September too since she has some client meetings there.I read a few years back that less than 10% of Americans have a passport, so if it helps you're not alone.
The State Department used to have an expedited passport issuance service, but that was also quite a while back.
Welcome to the post-911 NAFTA, which was supposed to make crossing the northern border easier.
'nuff said.
July 12, 2013 at 4:07 am
Revenant (7/11/2013)
dwain.c (7/11/2013)
Sean Lange (7/11/2013)
OK I will show my true American colors here. My wife's company just got a new client in Newfoundland. She is going to have to travel there this fall at some point and wants to take me with her. This sounds like a great opportunity. Then the realization that I don't have a passport hits me. This is probably unbelievable to many of you that a guy in his mid 40s doesn't have a passport. The US is a big place and I used to able to go to Canada and Mexico with no passport. The last time I truly traveled abroad was the summer I spent in England when I was 10. That means my passport expired more than 25 years ago. 😀 There are a lot of extra hoops to jump through because I have not had a passport for so long. It would actually be easier if I had never had one before. The upside is that if it comes through in time I should be able to spend a week in Vancouver in September too since she has some client meetings there.I read a few years back that less than 10% of Americans have a passport, so if it helps you're not alone.
The State Department used to have an expedited passport issuance service, but that was also quite a while back.
Welcome to the post-911 NAFTA, which was supposed to make crossing the northern border easier.
Well if Canada would quit trying to invade the U.S., maybe it would be easier!
Because we all know they're jealous of our hockey teams. @=)
July 12, 2013 at 5:45 am
Brandie Tarvin (7/12/2013)
Well if Canada would quit trying to invade the U.S., maybe it would be easier!Because we all know they're jealous of our hockey teams. @=)
Detroit Red Wings!
Toronto Maple Leafs!
January 1!
Let's get ready to RRRRRUUUUUUMMMMMMMBBBBBBBBLLLLLLLLEEEEEEEEEE!
(And I've got tickets! 😎 )
July 12, 2013 at 6:11 am
Sean Lange (7/11/2013)
OK I will show my true American colors here. My wife's company just got a new client in Newfoundland. She is going to have to travel there this fall at some point and wants to take me with her. This sounds like a great opportunity. Then the realization that I don't have a passport hits me. This is probably unbelievable to many of you that a guy in his mid 40s doesn't have a passport. The US is a big place and I used to able to go to Canada and Mexico with no passport. The last time I truly traveled abroad was the summer I spent in England when I was 10. That means my passport expired more than 25 years ago. 😀 There are a lot of extra hoops to jump through because I have not had a passport for so long. It would actually be easier if I had never had one before. The upside is that if it comes through in time I should be able to spend a week in Vancouver in September too since she has some client meetings there.
My passport gets within 6 months of expiring and I get very nervous.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 12, 2013 at 6:23 am
Sean Lange (7/11/2013)
OK I will show my true American colors here. My wife's company just got a new client in Newfoundland. She is going to have to travel there this fall at some point and wants to take me with her. This sounds like a great opportunity. Then the realization that I don't have a passport hits me. This is probably unbelievable to many of you that a guy in his mid 40s doesn't have a passport. The US is a big place and I used to able to go to Canada and Mexico with no passport. The last time I truly traveled abroad was the summer I spent in England when I was 10. That means my passport expired more than 25 years ago. 😀 There are a lot of extra hoops to jump through because I have not had a passport for so long. It would actually be easier if I had never had one before. The upside is that if it comes through in time I should be able to spend a week in Vancouver in September too since she has some client meetings there.
Is there a difference in the US between passport and ID? In Belgium we are obliged to carry ID at all times and this allows us to travel anywhere in the European union.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 12, 2013 at 6:27 am
Koen Verbeeck (7/12/2013)
Is there a difference in the US between passport and ID?
Yes, there is. Passport allows us to cross borders with other countries. ID could be anything from a driver's license to a state ID card (similar in size to a driver's license without the driving priviledges) to a student / military ID card, etc.
There are lots of definitions of what "ID" means in the States. Passport is just one of them.
EDIT: And there is no law (federal at least) that requires us to have our ID on us all the time. Most states I've lived in don't have that law either. It's just darned inconvienent to not have ID at hand when someone requests it in order to do business (mortgage, credit card use, drinking, etc.).
July 12, 2013 at 6:40 am
Brandie Tarvin (7/12/2013)
Koen Verbeeck (7/12/2013)
Is there a difference in the US between passport and ID?Yes, there is. Passport allows us to cross borders with other countries. ID could be anything from a driver's license to a state ID card (similar in size to a driver's license without the driving priviledges) to a student / military ID card, etc.
There are lots of definitions of what "ID" means in the States. Passport is just one of them.
EDIT: And there is no law (federal at least) that requires us to have our ID on us all the time. Most states I've lived in don't have that law either. It's just darned inconvienent to not have ID at hand when someone requests it in order to do business (mortgage, credit card use, drinking, etc.).
Ah, that explains why they ask "can I see some ID?" in the movies. 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 12, 2013 at 7:37 am
Steve Jones - SSC Editor (7/11/2013)
I renewed my passport last year. There still was expedited service, but I didn't choose it. Got mine in under 4 weeks.
I am not doing the expedited service either. I think I have all the paperwork collected and will submit it tomorrow. We will see how long it takes. I should be fine with the predicted 6-8 weeks but many people I have talked to have experience closer to 4 weeks.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 12, 2013 at 7:40 am
Koen Verbeeck (7/12/2013)
Brandie Tarvin (7/12/2013)
Koen Verbeeck (7/12/2013)
Is there a difference in the US between passport and ID?Yes, there is. Passport allows us to cross borders with other countries. ID could be anything from a driver's license to a state ID card (similar in size to a driver's license without the driving priviledges) to a student / military ID card, etc.
There are lots of definitions of what "ID" means in the States. Passport is just one of them.
EDIT: And there is no law (federal at least) that requires us to have our ID on us all the time. Most states I've lived in don't have that law either. It's just darned inconvienent to not have ID at hand when someone requests it in order to do business (mortgage, credit card use, drinking, etc.).
Ah, that explains why they ask "can I see some ID?" in the movies. 🙂
It is actually kind of funny in the US. For things like travel or other more official things you hear "some ID". When making a credit card purchase or age verification at a bar you generally hear "your ID", which I suspect is probably more common in Europe.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 12, 2013 at 7:54 am
Sean Lange (7/12/2013)
Steve Jones - SSC Editor (7/11/2013)
I renewed my passport last year. There still was expedited service, but I didn't choose it. Got mine in under 4 weeks.I am not doing the expedited service either. I think I have all the paperwork collected and will submit it tomorrow. We will see how long it takes. I should be fine with the predicted 6-8 weeks but many people I have talked to have experience closer to 4 weeks.
A couple years ago, I had to get one to go to China.
The expedited passport took 4 days, and the rest of approval for China took about a week.
Depends on who is pushing, and how many $ grease the wheels.
You may want to pop the extra $30 or so for the hard card for Canada / Mexico.
Also if you have a center in your city (which I did), check with them.
My daughter and spouse got theirs on a free day, no appt needed, and seemed much faster than the normal process.
July 12, 2013 at 7:59 am
Sean Lange (7/12/2013)
Steve Jones - SSC Editor (7/11/2013)
I renewed my passport last year. There still was expedited service, but I didn't choose it. Got mine in under 4 weeks.I am not doing the expedited service either. I think I have all the paperwork collected and will submit it tomorrow. We will see how long it takes. I should be fine with the predicted 6-8 weeks but many people I have talked to have experience closer to 4 weeks.
And the picture might be best to just go to something like CVS.
The format is pretty specific, and it's worth the $10 to make sure that is right.
Viewing 15 posts - 40,501 through 40,515 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply