February 26, 2016 at 11:54 am
Sean Lange (2/26/2016)
SQLRNNR (2/26/2016)
Sean Lange (2/26/2016)
Ed Wagner (2/26/2016)
Grumpy DBA (2/26/2016)
Hugo Kornelis (2/26/2016)
Grumpy DBA (2/26/2016)
For some unknown reason a terrible song has been stuck in my head each morning this week... Sheena Easton's Morning Train. It's equivalent to slow, painful torture. I have no reason why that turd of a song keeps popping in my head shortly after waking each morning - I do not take a train to work, my wife does not stay home and wait for me to take another train home... ugh.No problem, I can fix that. Here is a song that will kick every other song out of your head and never allow them back in again. Not sure if it's an improvement, though.
https://www.youtube.com/watch?v=iJFGAX77zw4
You're welcome. :satisfied:
We'll see tomorrow if I wake up to Morning Train or It's a Small World... not sure if I should be thanking you or cursing you, Hugo... lol...
Heh - I got back from Disney and we went on the ride. I don't need to click the link...it's already in my head.
It has been almost a month and a half since we got back and that song is still in MY head. Good luck Ed, that song sticks forever. It is the worst song ever written because it is super catchy and has no end. It is like a video game soundtrack on an endless loop.
Now it is stuck in my head. I didn't click the link or even go to Disney Cruise/Land/World.
And of course, having heard that tune via the Cruise ship horn, that version is now stuck in my head just thinking about the song and cruise together. Thanks. Yup Thanks.
You are quite welcome. Happy to share the joy. At least is isn't "All Out of Love" from Air Supply. :w00t:
True, we're so lost without you!
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 26, 2016 at 11:56 am
Grumpy DBA (2/26/2016)
Sean Lange (2/26/2016)
You are quite welcome. Happy to share the joy. At least is isn't "All Out of Love" from Air Supply. :w00t:
Well, that's a good thing because we all know "All Out of Love" is inferior to this Air Supply classic:
https://www.youtube.com/watch?v=rvVs0muI-gU
P.S. - how come I cannot embed URLs using the Insert Hyperlink button?
Doesn't work for me either. I just use the URL ifcode to the left of the reply box.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 26, 2016 at 11:57 am
Brandie Tarvin (2/26/2016)
Grumpy DBA (2/26/2016)
Sean Lange (2/26/2016)
You are quite welcome. Happy to share the joy. At least is isn't "All Out of Love" from Air Supply. :w00t:
Well, that's a good thing because we all know "All Out of Love" is inferior to this Air Supply classic:
https://www.youtube.com/watch?v=rvVs0muI-gU
P.S. - how come I cannot embed URLs using the Insert Hyperlink button?
Well, is the button complete greyed out? Or does it just do nothing when you click it? Or worse, does it keep putting the hyperlink elsewhere in your post when you try?
EDIT: Is this the point where I'm supposed to be ashamed to admit I'm an Air Supply fan?
Ironically the URL works in your quoted reply.
The button is not greyed out, this is what happens (another Air Supply hit for you, Super Fan!):
February 26, 2016 at 11:57 am
SQLRNNR (2/26/2016)
Grumpy DBA (2/26/2016)
Sean Lange (2/26/2016)
You are quite welcome. Happy to share the joy. At least is isn't "All Out of Love" from Air Supply. :w00t:
Well, that's a good thing because we all know "All Out of Love" is inferior to this Air Supply classic:
https://www.youtube.com/watch?v=rvVs0muI-gU
P.S. - how come I cannot embed URLs using the Insert Hyperlink button?
Doesn't work for me either. I just use the URL ifcode to the left of the reply box.
I'm able to make it work in Chrome.
February 26, 2016 at 12:06 pm
Grumpy DBA (2/26/2016)
Brandie Tarvin (2/26/2016)
Grumpy DBA (2/26/2016)
Sean Lange (2/26/2016)
You are quite welcome. Happy to share the joy. At least is isn't "All Out of Love" from Air Supply. :w00t:
Well, that's a good thing because we all know "All Out of Love" is inferior to this Air Supply classic:
https://www.youtube.com/watch?v=rvVs0muI-gU
P.S. - how come I cannot embed URLs using the Insert Hyperlink button?
Well, is the button complete greyed out? Or does it just do nothing when you click it? Or worse, does it keep putting the hyperlink elsewhere in your post when you try?
EDIT: Is this the point where I'm supposed to be ashamed to admit I'm an Air Supply fan?
Ironically the URL works in your quoted reply.
The button is not greyed out, this is what happens (another Air Supply hit for you, Super Fan!):
[ url= https://www.youtube.com/watch?v=ogoIxkPjRts%5D [ / url ]
Actually, it wasn't hyperlinked when I hit the quote button. I had to highlight it and hit the URL button.
What I do is paste my text into the comment window. Then highlight from right to left (though direction probably doesn't matter), then hit the URL button. When the little box pops up, I copy the link in the box and hit okay.
So when you hit EDIT or QUOTE on a post with a URL link, you should see this: [ url= https://www.youtube.com/watch?v=ogoIxkPjRts%5D [ /url ] but with text or the link between the middle right and left brackets or Here's where the text goes.
EDIT: had to fix the URL code so it wasn't linking the text of my reply
Quote my post and see if you can see it the way I do.
February 26, 2016 at 12:22 pm
Luis Cazares (2/26/2016)
SQLRNNR (2/26/2016)
Grumpy DBA (2/26/2016)
Sean Lange (2/26/2016)
You are quite welcome. Happy to share the joy. At least is isn't "All Out of Love" from Air Supply. :w00t:
Well, that's a good thing because we all know "All Out of Love" is inferior to this Air Supply classic:
https://www.youtube.com/watch?v=rvVs0muI-gU
P.S. - how come I cannot embed URLs using the Insert Hyperlink button?
Doesn't work for me either. I just use the URL ifcode to the left of the reply box.
I'm able to make it work in Chrome.
Firefox is also good.
February 26, 2016 at 12:49 pm
Brandie Tarvin (2/26/2016)
Grumpy DBA (2/26/2016)
Ironically the URL works in your quoted reply.
The button is not greyed out, this is what happens (another Air Supply hit for you, Super Fan!):
[ url= https://www.youtube.com/watch?v=ogoIxkPjRts%5D [ / url ]
Actually, it wasn't hyperlinked when I hit the quote button. I had to highlight it and hit the URL button.
What I do is paste my text into the comment window. Then highlight from right to left (though direction probably doesn't matter), then hit the URL button. When the little box pops up, I copy the link in the box and hit okay.
So when you hit EDIT or QUOTE on a post with a URL link, you should see this: [ url= https://www.youtube.com/watch?v=ogoIxkPjRts%5D [ /url ] but with text or the link between the middle right and left brackets or Here's where the text goes.
EDIT: had to fix the URL code so it wasn't linking the text of my reply
Quote my post and see if you can see it the way I do.
It works, as evidenced by the link above.
February 26, 2016 at 1:42 pm
I know this should go elsewhere but I feel that I'll get more responses here.
Why do organizations believe that they will get more candidates for a position when they use multiple agencies to seek out candidates? I know of a position with a school district in Colorado that is using between 6 and 12 local/national recruiting agencies to fill a position. This position has been open for several months. If they didn't specify no telecommute on the postings I might have considered applying. I really don't want to move at the moment.
February 26, 2016 at 1:49 pm
Lynn Pettis (2/26/2016)
I know this should go elsewhere but I feel that I'll get more responses here.Why do organizations believe that they will get more candidates for a position when they use multiple agencies to seek out candidates? I know of a position with a school district in Colorado that is using between 6 and 12 local/national recruiting agencies to fill a position. This position has been open for several months. If they didn't specify no telecommute on the postings I might have considered applying. I really don't want to move at the moment.
I see this all the time in Chicago. I don't think organizations always do it because they are searching for more candidates, they are testing out the agencies to see who does a better job at finding them a candidate. I have worked at a couple places that do that.
-- Itzik Ben-Gan 2001
February 26, 2016 at 1:56 pm
Alan.B (2/26/2016)
Lynn Pettis (2/26/2016)
I know this should go elsewhere but I feel that I'll get more responses here.Why do organizations believe that they will get more candidates for a position when they use multiple agencies to seek out candidates? I know of a position with a school district in Colorado that is using between 6 and 12 local/national recruiting agencies to fill a position. This position has been open for several months. If they didn't specify no telecommute on the postings I might have considered applying. I really don't want to move at the moment.
I see this all the time in Chicago. I don't think organizations always do it because they are searching for more candidates, they are testing out the agencies to see who does a better job at finding them a candidate. I have worked at a couple places that do that.
Well, I got hit by it once. The agency (a national agency that was more interested in patting themselves on the back for providing top talent to Fortune 500 companies) I went with made me a contractor for a contractor for the host company. Had I gone with a local agency I would have been a direct contractor with the company and the agency would have done more for me or guided me away from the company.
Since then I have looked very closely at the multiple job postings so that I don't apply (if I were to apply) for the same position through multiple agencies. I know that can cost a job offer in the government contracting arena. For those who are not as diligent it could cause problems for them during a job search.
February 26, 2016 at 2:12 pm
Public Service Announcement
For those who wish to submit sessions for the 2016 PASS Summit the deadline for submission is Wednesday, March 2. I have started working on my abstracts and I see that at least Gail and Grant have submitted several.
So get to work on those abstracts this weekend! No reason all the folks on The Thread shouldn't submit, especially since I'm not on the Program Committee this year so I con't have to either review all the abstracts or speakers (more work). 😀
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
February 26, 2016 at 2:23 pm
Lynn Pettis (2/26/2016)
Alan.B (2/26/2016)
Lynn Pettis (2/26/2016)
I know this should go elsewhere but I feel that I'll get more responses here.Why do organizations believe that they will get more candidates for a position when they use multiple agencies to seek out candidates? I know of a position with a school district in Colorado that is using between 6 and 12 local/national recruiting agencies to fill a position. This position has been open for several months. If they didn't specify no telecommute on the postings I might have considered applying. I really don't want to move at the moment.
I see this all the time in Chicago. I don't think organizations always do it because they are searching for more candidates, they are testing out the agencies to see who does a better job at finding them a candidate. I have worked at a couple places that do that.
Well, I got hit by it once. The agency (a national agency that was more interested in patting themselves on the back for providing top talent to Fortune 500 companies) I went with made me a contractor for a contractor for the host company. Had I gone with a local agency I would have been a direct contractor with the company and the agency would have done more for me or guided me away from the company.
Since then I have looked very closely at the multiple job postings so that I don't apply (if I were to apply) for the same position through multiple agencies. I know that can cost a job offer in the government contracting arena. For those who are not as diligent it could cause problems for them during a job search.
The really challenging part of it is that all these agencies like to keep the company name a secret unless you are going for an interview. At least in this area I get calls from any recruiter (or agency they ever worked for) all the time. Now I don't go looking for new jobs as I have been at my current position for almost 8 years and have no intention of leaving. But if I was it would be frustrating to have the same job from multiple agencies. Wastes my time and theirs.
_______________________________________________________________
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/
February 26, 2016 at 2:38 pm
Lynn Pettis (2/26/2016)
Alan.B (2/26/2016)
Lynn Pettis (2/26/2016)
I know this should go elsewhere but I feel that I'll get more responses here.Why do organizations believe that they will get more candidates for a position when they use multiple agencies to seek out candidates? I know of a position with a school district in Colorado that is using between 6 and 12 local/national recruiting agencies to fill a position. This position has been open for several months. If they didn't specify no telecommute on the postings I might have considered applying. I really don't want to move at the moment.
I see this all the time in Chicago. I don't think organizations always do it because they are searching for more candidates, they are testing out the agencies to see who does a better job at finding them a candidate. I have worked at a couple places that do that.
Well, I got hit by it once. The agency (a national agency that was more interested in patting themselves on the back for providing top talent to Fortune 500 companies) I went with made me a contractor for a contractor for the host company. Had I gone with a local agency I would have been a direct contractor with the company and the agency would have done more for me or guided me away from the company.
Since then I have looked very closely at the multiple job postings so that I don't apply (if I were to apply) for the same position through multiple agencies. I know that can cost a job offer in the government contracting arena. For those who are not as diligent it could cause problems for them during a job search.
A good agency will tell you who the company is if they decide to submit you then ask if you've already been submitted before submitting you.
-- Itzik Ben-Gan 2001
February 26, 2016 at 2:48 pm
Sean Lange (2/26/2016)
Lynn Pettis (2/26/2016)
Alan.B (2/26/2016)
Lynn Pettis (2/26/2016)
I know this should go elsewhere but I feel that I'll get more responses here.Why do organizations believe that they will get more candidates for a position when they use multiple agencies to seek out candidates? I know of a position with a school district in Colorado that is using between 6 and 12 local/national recruiting agencies to fill a position. This position has been open for several months. If they didn't specify no telecommute on the postings I might have considered applying. I really don't want to move at the moment.
I see this all the time in Chicago. I don't think organizations always do it because they are searching for more candidates, they are testing out the agencies to see who does a better job at finding them a candidate. I have worked at a couple places that do that.
Well, I got hit by it once. The agency (a national agency that was more interested in patting themselves on the back for providing top talent to Fortune 500 companies) I went with made me a contractor for a contractor for the host company. Had I gone with a local agency I would have been a direct contractor with the company and the agency would have done more for me or guided me away from the company.
Since then I have looked very closely at the multiple job postings so that I don't apply (if I were to apply) for the same position through multiple agencies. I know that can cost a job offer in the government contracting arena. For those who are not as diligent it could cause problems for them during a job search.
The really challenging part of it is that all these agencies like to keep the company name a secret unless you are going for an interview.
Which is a good idea. Otherwise the candidate could just say they're not interested and go directly to the company. Companies always prefer the candidates they find directly because they don't have to pay commission to anyone. Recruiters/headhunters commission can be pretty high.
-- Itzik Ben-Gan 2001
February 26, 2016 at 2:51 pm
Alan.B (2/26/2016)
Sean Lange (2/26/2016)
Lynn Pettis (2/26/2016)
Alan.B (2/26/2016)
Lynn Pettis (2/26/2016)
I know this should go elsewhere but I feel that I'll get more responses here.Why do organizations believe that they will get more candidates for a position when they use multiple agencies to seek out candidates? I know of a position with a school district in Colorado that is using between 6 and 12 local/national recruiting agencies to fill a position. This position has been open for several months. If they didn't specify no telecommute on the postings I might have considered applying. I really don't want to move at the moment.
I see this all the time in Chicago. I don't think organizations always do it because they are searching for more candidates, they are testing out the agencies to see who does a better job at finding them a candidate. I have worked at a couple places that do that.
Well, I got hit by it once. The agency (a national agency that was more interested in patting themselves on the back for providing top talent to Fortune 500 companies) I went with made me a contractor for a contractor for the host company. Had I gone with a local agency I would have been a direct contractor with the company and the agency would have done more for me or guided me away from the company.
Since then I have looked very closely at the multiple job postings so that I don't apply (if I were to apply) for the same position through multiple agencies. I know that can cost a job offer in the government contracting arena. For those who are not as diligent it could cause problems for them during a job search.
The really challenging part of it is that all these agencies like to keep the company name a secret unless you are going for an interview.
Which is a good idea. Otherwise the candidate could just say they're not interested and go directly to the company. Companies always prefer the candidates they find directly because they don't have to pay commission to anyone. Recruiters/headhunters commission can be pretty high.
I get it and it makes sense for the recruiter. It is challenging for the job seeker when multiple agencies all try to fill the same position. That happened once and my resume was submitted twice. In the interview I was asked why my experience was different on each resume. I was really glad I had a couple hard copies of my resume because neither of the ones received had the same information as the one I wrote.
_______________________________________________________________
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/
Viewing 15 posts - 52,936 through 52,950 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply