March 10, 2014 at 10:23 am
Luis Cazares (3/10/2014)
Ed Wagner (3/10/2014)
Luis Cazares (3/10/2014)
Good Monday everyone,I've been away for a week and seems a lot to me. I moved to a different area in my company and I've been adapting and learning (and struggling with the lack of internet access).
Congratulations to Jack on his new job.
If you want to talk about traffic, It takes me about an hour to get to work when it should take me about 20min. That's the price of living in one of the most populated cities in the world.
Congratulations on your new spot, Luis, if congratulations are in order. I'm sorry to hear about the lack of internet; that makes life much harder sometimes. On you traffic comment, I hear your pain. Before I moved, my commute took about 18 minutes during non-peak times. During rush hour, it would take about 75 minutes one way. Moving was such a relief. You don't realize how much time you waste sitting in traffic until you measure it. You then realize how big of an impact it has on your life once you get it back.
It's basically the same position but within a different area (I'll have to clean the mess all over again). My former teammates reminded me of configuring the proxy and I'm back online.:-D
See what you get for being good at your job? 😉 At least you'll get job satisfaction out of the deal.
March 10, 2014 at 12:14 pm
GilaMonster (3/10/2014)
Jack Corbett (3/10/2014)
My job title is Data Software Development Leader. I'll be doing a lot of design and architecture work. I'm going to kind of span the MS Data Platform by being an advisor to the DBA, doing T-SQL Development, and BI work (SSIS, SSRS).Technical Lead: SQL Server. Technically means I'm in charge of the direction, design and architecture of any SQL Server portion of any application we develop. Practically means not very much. But I can't work entirely from home as I have to be around for all the 'how do I write a delete query' type questions.
What do you mean I can't use "Truncate table" with a where clause?
:hehe:;-)
March 10, 2014 at 1:56 pm
Jack Corbett (3/10/2014)
Koen Verbeeck (3/10/2014)
Jack Corbett (3/10/2014)
Yeah, that's going to be a bit tough because of the lost time (90 minutes travel a day) and the loss of flexibility, but, there aren't as many FT telecommute jobs out there as there could be. The CIO at this company did say he is working on changing the culture to allow more remote work so there is some hope that there will be some change moving forward.This is a good company that has a track record of retaining employees because they treat you well. They value training as well.
Is that 90 minutes up and 90 minutes in return? Ouch.
Important though they value training.
No just 90 minutes total, and that's probably actually longer than it'll actual take most days. It's only about 18 miles each way, and most days will only take 30 minutes each way, but any traffic or weather issues could up to double it. It's about as long as I want to travel. If it was 90 minutes each way I'd have negotiated at least 3 days a week telecommute.
To answer Jason's question. I'm in the process of accepting the first one because the 2nd one hasn't gotten back to me yet and I think the 1st one is the better job career wise. I called and left a message this morning saying I was accepting the offer. The HR person was not at her desk when I called. Probably in a meeting. I'm going to call again.
90 minutes is what I usually drive on an average day.
Although I usually take the train now. About 75 minutes total, and I can read books or watch some 24h of Pass videos.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 10, 2014 at 1:57 pm
SQLRNNR (3/10/2014)
errrmmmhttp://www.sqlservercentral.com/Forums/FindPost1549320.aspx :Whistling: :unsure:
Whoops. Maybe I should send him a consulting offer. 😎
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 10, 2014 at 2:14 pm
If any one has some free time this person could use some help. I don't have the free time at the moment.
http://www.sqlservercentral.com/Forums/Topic1549023-391-1.aspx
March 10, 2014 at 2:32 pm
Koen Verbeeck (3/10/2014)
SQLRNNR (3/10/2014)
errrmmmhttp://www.sqlservercentral.com/Forums/FindPost1549320.aspx :Whistling: :unsure:
Whoops. Maybe I should send him a consulting offer. 😎
Pretty sad when they want someone to just do their homework.
Almost makes a person want to come up with a complex solution that is flawed.
And be in the corner of the room as they explain their master level skills to the instructor.:-D
March 10, 2014 at 2:36 pm
Greg Edwards-268690 (3/10/2014)
Koen Verbeeck (3/10/2014)
SQLRNNR (3/10/2014)
errrmmmhttp://www.sqlservercentral.com/Forums/FindPost1549320.aspx :Whistling: :unsure:
Whoops. Maybe I should send him a consulting offer. 😎
Pretty sad when they want someone to just do their homework.
Almost makes a person want to come up with a complex solution that is flawed.
And be in the corner of the room as they explain their master level skills to the instructor.:-D
Homework is one thing. But this was the test. Pretty brazen imho.
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
March 10, 2014 at 2:41 pm
Lynn Pettis (3/10/2014)
If any one has some free time this person could use some help. I don't have the free time at the moment.http://www.sqlservercentral.com/Forums/Topic1549023-391-1.aspx
I've wasted a lot of time with that person, but he seems to haven't learn a thing. Maybe someone else.
March 10, 2014 at 2:48 pm
Luis Cazares (3/10/2014)
Lynn Pettis (3/10/2014)
If any one has some free time this person could use some help. I don't have the free time at the moment.http://www.sqlservercentral.com/Forums/Topic1549023-391-1.aspx
I've wasted a lot of time with that person, but he seems to haven't learn a thing. Maybe someone else.
They know Jeff is one of the best, so they have learned something.
Coming from a data warehouse, running SSAS, it made me cringe a bit.
Maybe more than a bit. :w00t:
March 10, 2014 at 2:53 pm
SQLRNNR (3/10/2014)
Greg Edwards-268690 (3/10/2014)
Koen Verbeeck (3/10/2014)
SQLRNNR (3/10/2014)
errrmmmhttp://www.sqlservercentral.com/Forums/FindPost1549320.aspx :Whistling: :unsure:
Whoops. Maybe I should send him a consulting offer. 😎
Pretty sad when they want someone to just do their homework.
Almost makes a person want to come up with a complex solution that is flawed.
And be in the corner of the room as they explain their master level skills to the instructor.:-D
Homework is one thing. But this was the test. Pretty brazen imho.
Yeah pretty pathetic to say the least. This person will probably BS there way right up to the top and then be critical of the work the technical people do.
_______________________________________________________________
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 10, 2014 at 2:58 pm
Sean Lange (3/10/2014)
SQLRNNR (3/10/2014)
Greg Edwards-268690 (3/10/2014)
Koen Verbeeck (3/10/2014)
SQLRNNR (3/10/2014)
errrmmmhttp://www.sqlservercentral.com/Forums/FindPost1549320.aspx :Whistling: :unsure:
Whoops. Maybe I should send him a consulting offer. 😎
Pretty sad when they want someone to just do their homework.
Almost makes a person want to come up with a complex solution that is flawed.
And be in the corner of the room as they explain their master level skills to the instructor.:-D
Homework is one thing. But this was the test. Pretty brazen imho.
Yeah pretty pathetic to say the least. This person will probably BS there way right up to the top and then be critical of the work the technical people do.
I really should send him a tender. At least he can get used to expensive consultants doing the work for him. :hehe:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 10, 2014 at 6:52 pm
Jack Corbett (3/7/2014)
So for those of you who knew I was unemployed. I have an offer on the table. The only problem is that it involves going back to "real" work with hard deadlines, accountability, and going into an office. None of those are bad things, but it's just been a couple years since I've had all 3. The last job was a full-time telecommute and they thought they had hard deadlines and accountability, but it not really, and prior to that working for a non-profit where they were happy you there.I haven't accepted yet because another company is also interested in making an offer and I'm giving them a chance to see what they can come up with. The current offer is good and the benefits the come with the current offer are top shelf, so it'll be very hard to top.
Congrats!
March 10, 2014 at 11:57 pm
Sean Lange (3/10/2014)
SQLRNNR (3/10/2014)
Greg Edwards-268690 (3/10/2014)
Koen Verbeeck (3/10/2014)
SQLRNNR (3/10/2014)
errrmmmhttp://www.sqlservercentral.com/Forums/FindPost1549320.aspx :Whistling: :unsure:
Whoops. Maybe I should send him a consulting offer. 😎
Pretty sad when they want someone to just do their homework.
Almost makes a person want to come up with a complex solution that is flawed.
And be in the corner of the room as they explain their master level skills to the instructor.:-D
Homework is one thing. But this was the test. Pretty brazen imho.
Yeah pretty pathetic to say the least. This person will probably BS there way right up to the top and then be critical of the work the technical people do.
I have to admit, I really bit my tongue on that one. It's been a while since I've been so absolutely disgusted with someone. The problem is, he'll have learned his lesson and go to another forum without mentioning the test. One can only hope he doesn't change the wording of the problem, which is a dead giveaway.
--Jeff Moden
Change is inevitable... Change for the better is not.
March 11, 2014 at 12:08 am
Greg Edwards-268690 (3/10/2014)
Luis Cazares (3/10/2014)
Lynn Pettis (3/10/2014)
If any one has some free time this person could use some help. I don't have the free time at the moment.http://www.sqlservercentral.com/Forums/Topic1549023-391-1.aspx
I've wasted a lot of time with that person, but he seems to haven't learn a thing. Maybe someone else.
They know Jeff is one of the best, so they have learned something.
Coming from a data warehouse, running SSAS, it made me cringe a bit.
Maybe more than a bit. :w00t:
Thank you for the kind words. He's been PMing me and I've been telling him I'm not his private consultant. The first PM was to "Geff"... he couldn't even get my 4 letter name right and I let him know about it.
He is good with the compliments but I've not had the time to even run his triple nested, horribly formatted code through a reformatter just to try to figure out what he was doing. I'm tickled that someone like Dwain (or any of the heavy hitters) jumped in on that one. Thanks for the leg up.
--Jeff Moden
Change is inevitable... Change for the better is not.
March 11, 2014 at 12:14 am
Jeff Moden (3/11/2014)
Greg Edwards-268690 (3/10/2014)
Luis Cazares (3/10/2014)
Lynn Pettis (3/10/2014)
If any one has some free time this person could use some help. I don't have the free time at the moment.http://www.sqlservercentral.com/Forums/Topic1549023-391-1.aspx
I've wasted a lot of time with that person, but he seems to haven't learn a thing. Maybe someone else.
They know Jeff is one of the best, so they have learned something.
Coming from a data warehouse, running SSAS, it made me cringe a bit.
Maybe more than a bit. :w00t:
Thank you for the kind words. He's been PMing me and I've been telling him I'm not his private consultant. The first PM was to "Geff"... he couldn't even get my 4 letter name right and I let him know about it.
He is good with the compliments but I've not had the time to even run his triple nested, horribly formatted code through a reformatter just to try to figure out what he was doing. I'm tickled that someone like Dwain (or any of the heavy hitters) jumped in on that one. Thanks for the leg up.
Hmmm. Heavy hitter, huh? And here I thought I was just a SQL Enthusiast. (I'll take that as a compliment)
You'll note how I deflected his request to modify it to his exacting requirements. If he's truly born 2 achieve, he should be putting in a little of his own effort to make it work.
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
Viewing 15 posts - 43,246 through 43,260 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply