March 24, 2016 at 8:04 am
Brandie Tarvin (3/24/2016)
I need some SSIS script task help (2008 / 2012) over on this thread here. All assistance would be appreciated.Google doesn't seem to recognize the first error at all and the third error is so generic (and sometimes throws on my machine because TFS is stupid even when a file exists)... The frustration is threatening to set in.
Format everything and reinstall. If that doesn't work, buy new equipment. If it still doesn't work, consider working on Uber. 😀
(Hope you find a better solution)
March 24, 2016 at 8:05 am
Sean Lange (3/24/2016)
Eirikur Eiriksson (3/24/2016)
Sean Lange (3/24/2016)
--I posted in another thread by accident a couple of days ago--Thank you Mr. Moden. Another interview cut short with the simple "Name one way to get the current system time from sql server".
"That's easy, if it is IBM iSeries then just press the centre blue button under the display":-D
😎
And when asked about SSIS, SSAS and SSRS the response was "I don't really have much experience with those". I told them I was a little surprised since those terms were on their resume no less than a dozen times each.
Probably the experience was watching someone else work on them or writing them on the resume.
March 24, 2016 at 8:10 am
Luis Cazares (3/24/2016)
Brandie Tarvin (3/24/2016)
I need some SSIS script task help (2008 / 2012) over on this thread here. All assistance would be appreciated.Google doesn't seem to recognize the first error at all and the third error is so generic (and sometimes throws on my machine because TFS is stupid even when a file exists)... The frustration is threatening to set in.
Format everything and reinstall. If that doesn't work, buy new equipment. If it still doesn't work, consider working on Uber. 😀
(Hope you find a better solution)
Luis, if all of life's problems were that easily solved, we'd all be driving for Uber. @=)
March 24, 2016 at 8:13 am
Sean Lange (3/24/2016)
--I posted in another thread by accident a couple of days ago--Thank you Mr. Moden. Another interview cut short with the simple "Name one way to get the current system time from sql server".
This would have saved us a little time yesterday. The candidate failed all eight of the simple questions. No idea what was on the cv but these questions are only given to TSQL candidates claiming a good deal of experience.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 24, 2016 at 8:21 am
ChrisM@Work (3/24/2016)
Sean Lange (3/24/2016)
--I posted in another thread by accident a couple of days ago--Thank you Mr. Moden. Another interview cut short with the simple "Name one way to get the current system time from sql server".
This would have saved us a little time yesterday. The candidate failed all eight of the simple questions. No idea what was on the cv but these questions are only given to TSQL candidates claiming a good deal of experience.
Oh, dear. Now you have me wanting to know the questions to see if I could answer them... Not that I've ever claimed a "good deal" of experience. I'd say I'm fair to middlin'.
March 24, 2016 at 8:21 am
Hey guys just to let you know few things. Firstly if you recall I wrote my first ever article on SQL dashboards last year, well I have moved the project to code plex so anyone can use it.
Secondly I am in the process of building an iTunes U SQL podcasts library where I will be doing couple modules on basic SQL topics ( nothing like the stuff I went to on sqlskills training) followed by quick fire tests. Anyone interested let me know I will message them once done. Happy Easter.
March 24, 2016 at 8:21 am
ChrisM@Work (3/24/2016)
Sean Lange (3/24/2016)
--I posted in another thread by accident a couple of days ago--Thank you Mr. Moden. Another interview cut short with the simple "Name one way to get the current system time from sql server".
This would have saved us a little time yesterday. The candidate failed all eight of the simple questions. No idea what was on the cv but these questions are only given to TSQL candidates claiming a good deal of experience.
Having heard Jeff talk about how few people can answer this I decided to give it a try. So far 0 for 2. We are not hiring a DBA or anything that deal exclusively with sql. We are hiring for a developer. But in our shop the developers all deal with sql routinely. It is amazing to read things like "complex stored procedures and triggers". Then can't answer the simple things like how to get the current time. The best response to a question so far was this one. I asked them to briefly explain sql injection and some ways we can prevent it. After watching the person struggle for a couple minutes they started talking about how we can leverage sql injection dependency to improve performance. I somehow managed to keep a straight face as they made this up. :w00t:
_______________________________________________________________
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/
March 24, 2016 at 8:22 am
Brandie Tarvin (3/24/2016)
ChrisM@Work (3/24/2016)
Sean Lange (3/24/2016)
--I posted in another thread by accident a couple of days ago--Thank you Mr. Moden. Another interview cut short with the simple "Name one way to get the current system time from sql server".
This would have saved us a little time yesterday. The candidate failed all eight of the simple questions. No idea what was on the cv but these questions are only given to TSQL candidates claiming a good deal of experience.
Oh, dear. Now you have me wanting to know the questions to see if I could answer them... Not that I've ever claimed a "good deal" of experience. I'd say I'm fair to middlin'.
Same here Brandie. I always figure the questions asked by threadizens would make me cry. 🙂
_______________________________________________________________
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/
March 24, 2016 at 8:29 am
Sean Lange (3/24/2016)
... I always figure the questions asked by threadizens would make me cry. 🙂
Cry, I'd be too afraid to go to the interview :pinch:
Far away is close at hand in the images of elsewhere.
Anon.
March 24, 2016 at 8:30 am
Brandie Tarvin (3/24/2016)
ChrisM@Work (3/24/2016)
Sean Lange (3/24/2016)
--I posted in another thread by accident a couple of days ago--Thank you Mr. Moden. Another interview cut short with the simple "Name one way to get the current system time from sql server".
This would have saved us a little time yesterday. The candidate failed all eight of the simple questions. No idea what was on the cv but these questions are only given to TSQL candidates claiming a good deal of experience.
Oh, dear. Now you have me wanting to know the questions to see if I could answer them... Not that I've ever claimed a "good deal" of experience. I'd say I'm fair to middlin'.
I don't want to be held responsible for you messing up your monitor with whatever you're currently consuming Brandie. Honestly, they were incredibly simple. The score for each one was 0 or 1. That simple. To be a little more specific, the answer to one of them was
SELECT UserID, cnt = COUNT(*) FROM Users GROUP BY UserID.
The question wasn't in the least bit cryptic - and yet the candidate introduced the other table into his query.
When in doubt, just join in all the tables!!
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 24, 2016 at 8:37 am
ChrisM@Work (3/24/2016)
Brandie Tarvin (3/24/2016)
ChrisM@Work (3/24/2016)
Sean Lange (3/24/2016)
--I posted in another thread by accident a couple of days ago--Thank you Mr. Moden. Another interview cut short with the simple "Name one way to get the current system time from sql server".
This would have saved us a little time yesterday. The candidate failed all eight of the simple questions. No idea what was on the cv but these questions are only given to TSQL candidates claiming a good deal of experience.
Oh, dear. Now you have me wanting to know the questions to see if I could answer them... Not that I've ever claimed a "good deal" of experience. I'd say I'm fair to middlin'.
I don't want to be held responsible for you messing up your monitor with whatever you're currently consuming Brandie. Honestly, they were incredibly simple. The score for each one was 0 or 1. That simple. To be a little more specific, the answer to one of them was
SELECT UserID, cnt = COUNT(*) FROM Users GROUP BY UserID.
The question wasn't in the least bit cryptic - and yet the candidate introduced the other table into his query.
When in doubt, just join in all the tables!!
I'm debating on whether I like or dislike my desk right now... Nah, I've given it enough abuse this morning with my headdesking on other things. I think this time I'll just lean back in my chair and sigh.
SIIIIGGGGGHHHHH. I feel for you, Chris. I really truly do.
March 24, 2016 at 8:38 am
Brandie Tarvin (3/24/2016)
<headdesk>One of my coworkers just came up with the worst joke ever.
Three DBAs walk into a NoSQL bar. Soon after, they leave - they couldn't join a table!
Will G.
That's similar to the old joke:
A DBA walks in to a bar, sees a set of tables, walks up to them and asks, "may I join you?"
-- Itzik Ben-Gan 2001
March 24, 2016 at 8:44 am
Alan.B (3/24/2016)
Brandie Tarvin (3/24/2016)
<headdesk>One of my coworkers just came up with the worst joke ever.
Three DBAs walk into a NoSQL bar. Soon after, they leave - they couldn't join a table!
Will G.
That's similar to the old joke:
A DBA walks in to a bar, sees a set of tables, walks up to them and asks, "may I join you?"
Sounds like a perfect UNION to me. :hehe:
_______________________________________________________________
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/
March 24, 2016 at 8:47 am
Sean Lange (3/24/2016)
ChrisM@Work (3/24/2016)
Sean Lange (3/24/2016)
--I posted in another thread by accident a couple of days ago--Thank you Mr. Moden. Another interview cut short with the simple "Name one way to get the current system time from sql server".
This would have saved us a little time yesterday. The candidate failed all eight of the simple questions. No idea what was on the cv but these questions are only given to TSQL candidates claiming a good deal of experience.
Having heard Jeff talk about how few people can answer this I decided to give it a try. So far 0 for 2. We are not hiring a DBA or anything that deal exclusively with sql. We are hiring for a developer. But in our shop the developers all deal with sql routinely. It is amazing to read things like "complex stored procedures and triggers". Then can't answer the simple things like how to get the current time. The best response to a question so far was this one. I asked them to briefly explain sql injection and some ways we can prevent it. After watching the person struggle for a couple minutes they started talking about how we can leverage sql injection dependency to improve performance. I somehow managed to keep a straight face as they made this up. :w00t:
I know the struggle to keep the straight face. I've watched people trying to explain the difference between JOIN and INNER JOIN or LEFT JOIN and LEFT OUTER JOIN. And those were for SQL only positions.
March 24, 2016 at 9:15 am
ThomasRushton (3/24/2016)
rodjkidd (3/24/2016)
ChrisM@Work (3/23/2016)
How many of you contractors have been so taken with a gig that you've signed up as a permie? I just did. I never expected that.The idea of presenting fills me with irrational fear, and yet yesterday I gave a one-hour presentation on query tuning and execution plan basics to an alarmingly large group here in the biggest meeting room we have ("we"! Did you notice that?), and it wasn't too bad. They want more, Tuning Tuesdays, every other week. I never expected that.
Congrats Chris,
Haven't been tempted myself yet!
Cheers,
Rodders...
In a previous place, I was offered the "opportunity" of a permie job doing the contract work that I'd just signed up for. I turned that down, and ended up working a *very* long contract... And I still think I made the right choice, given the way the firm in question is going!
It's nice when it happens that way round too!
Rodders...
Viewing 15 posts - 53,221 through 53,235 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply