Viewing 15 posts - 796 through 810 (of 842 total)
I went to a community college, a 18 month straight program with courses on computer programming. None of the what I call 'filler' courses you have to take at...
September 16, 2013 at 8:24 am
I agree I would do left joins also, I can't remember writing a right join. I didn't post the code, and I'm sorry when I read your post I...
September 12, 2013 at 8:16 am
I agree with Sean's version. As you have found out this is a nightmare to figure out, it may work but it doesn't make it right. I think...
September 12, 2013 at 7:55 am
jmoney 69422 (9/11/2013)
...I devised a problem for them to solve.
Great idea, if I was interviewing I would like this approach.:-) Got any openings? 🙂 Just kidding, or am...
September 11, 2013 at 10:45 am
I agree with Dave62 on this, a probation period of 6 months. That's what my company has and it has worked for us, some mistakes but that can be...
September 11, 2013 at 9:50 am
I was once fired on a Monday morning, I would have preferred the prior Friday. I would think they knew before I left on Friday that this was going...
September 9, 2013 at 7:17 am
It's realy hard to understand what you are after here is it the 'Diff' can not be zero to send email or if number of rows returned is not zero...
September 6, 2013 at 7:43 am
Steve Jones - SSC Editor (9/5/2013)
And for the lighter side of interviews:
Now that there is funny, I don't care who you are. 🙂
September 5, 2013 at 12:08 pm
I wasn't asked any weird questions but I was asked to solve a puzzle. It was one of those puzzles where you needed to only move a couple pieces...
September 5, 2013 at 7:45 am
Until recently we didn't use the 'included' on our indexes. We started adding fields to existing indexes, we didn't run into a limit but ran into another problem. ...
August 27, 2013 at 2:05 pm
I don't know if it really applies to your code but we found turning some 'functions' that were just big case statements into a 'reference' table. This really sped...
August 27, 2013 at 8:35 am
I get it now, it was throwing me off when you said 'line', I was thinking the actual line number.
Maybe this is just me not understanding stored procedures but let's...
August 22, 2013 at 2:58 pm
Thanks 'You name Here', its been a good day for gaining new knowledge. Not real sure where or when I would need to do this but I will try...
August 22, 2013 at 1:10 pm
Eric M Russell (8/22/2013)
Chrissy321 (8/22/2013)
And as I stated earlied how do you look at a log for a stored procedure? If I have a 1000 line SQL with 50...
August 22, 2013 at 1:05 pm
Chrissy321 (8/22/2013)
And as I stated earlied how do you look at a log for a stored procedure? If I have a 1000 line SQL with 50 different SQL statements...
August 22, 2013 at 12:25 pm
Viewing 15 posts - 796 through 810 (of 842 total)