September 26, 2013 at 12:37 pm
Lynn Pettis (9/26/2013)
I know most Threadizens know I am currently deployed in Afghanistan as a civilian contractor.I was notified this evening that my position state side has been cut as part of company layoff. Unlike my fellow workers state side whose last day of employment is tomorrow, I still have a job here in Afghanistan. What I don't have is a job to come home to now. It looks like I will also be extending out here until February 2014 at this time as well (Yea me!! And yes, I am excited about this).
What this means is I am reaching out to start my job search now while I am still working. Yes, I would like to stay out here as long as possible. The money is really good and offers me the opportunity to put money aside should I come home to a continuing job search.
I will be reworking my resume over the next week or so. I would like to stay in the Colorado Springs area as I still have a daughter in High School (she is a sophomore now).
I telecommute position would be ideal.
With this news, I have some other news.
My ex-wife and I are getting back together. Yes, we are giving reconciliation a try. This deployment to Afghanistan opened a door and we both stepped through.
For me it started when she and my youngest daughter took me to the airport to start my journey to Afghanistan. She started to cry as we said good bye at the airport. I couldn't stop myself from telling her I loved her.
We have talked openly almost every day since then. It has been a blessed journey for me, and a confusing one for her.
It was during our talks I found out it started for her the night before I left while she was fixing my going away dinner. I stayed at her (our) house that night having moved out of my apartment that day so she and Kylie could take me to the airport the following morning.
Great to hear things are looking up for you, Lynn! Sadly, I don't know of many job opportunities in my area, or I'd pass one along to you. It's heartwarming to hear that you and your wife are trying to work things out, and I'm hoping for the best for you.
Also, I admire you quite a bit for wanting to go out to Afghanistan to work on improving things out there; that's admittedly something I probably wouldn't have the nerves to do. Hopefully your job search goes well, and people will respect the service you're currently providing as a sign of dedication.
- 😀
September 26, 2013 at 2:37 pm
Lynn Pettis (9/26/2013)
My ex-wife and I are getting back together. Yes, we are giving reconciliation a try. This deployment to Afghanistan opened a door and we both stepped through.
That is good news. Keep working at it.
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
September 26, 2013 at 2:39 pm
Aaaaaaargh... And now, I need to fume :-P.
Working with the company's vendor software, and one of the reports is coming across super-slow, about 10 minutes to retrieve about 150 items. Caught the code with Profiler, and... It's got a DISTINCT on a list of fields that's about 30 items long. Pluck the DISTINCT out, and the code drops from 10 minutes to run to three seconds, with identical results in all test cases.
Sadly, the report query isn't being held in a proc in the database; it's being assembled in the ASP.net front-end, and run from there. As far as I know of, I can't reach in there and rip the offending bit out. Is there some way of handling this, or should I introduce my forehead to my desk a few times? 🙂
- 😀
September 26, 2013 at 2:43 pm
hisakimatama (9/26/2013)
Aaaaaaargh... And now, I need to fume :-P.Working with the company's vendor software, and one of the reports is coming across super-slow, about 10 minutes to retrieve about 150 items. Caught the code with Profiler, and... It's got a DISTINCT on a list of fields that's about 30 items long. Pluck the DISTINCT out, and the code drops from 10 minutes to run to three seconds, with identical results in all test cases.
Sadly, the report query isn't being held in a proc in the database; it's being assembled in the ASP.net front-end, and run from there. As far as I know of, I can't reach in there and rip the offending bit out. Is there some way of handling this, or should I introduce my forehead to my desk a few times? 🙂
So, the report is also an ASP .Net page (doesn't reference an SSRS or Crystal type report)?
Either way, it's a perfect example of evidence to beat on the vendor about. Take the evidence to them and tell them to fix it.
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
September 26, 2013 at 2:52 pm
SQLRNNR (9/26/2013)
hisakimatama (9/26/2013)
Aaaaaaargh... And now, I need to fume :-P.Working with the company's vendor software, and one of the reports is coming across super-slow, about 10 minutes to retrieve about 150 items. Caught the code with Profiler, and... It's got a DISTINCT on a list of fields that's about 30 items long. Pluck the DISTINCT out, and the code drops from 10 minutes to run to three seconds, with identical results in all test cases.
Sadly, the report query isn't being held in a proc in the database; it's being assembled in the ASP.net front-end, and run from there. As far as I know of, I can't reach in there and rip the offending bit out. Is there some way of handling this, or should I introduce my forehead to my desk a few times? 🙂
So, the report is also an ASP .Net page (doesn't reference an SSRS or Crystal type report)?
Either way, it's a perfect example of evidence to beat on the vendor about. Take the evidence to them and tell them to fix it.
Yep, the report's an ASP.Net page too; there's a SSRS report base in the software, but it's unused.
And poking the vendor about the issue... *Shudder*. This company's had issues with the software almost from day 1 for all kinds of reasons. Their search functions are SQL-injectable, and we've reported it multiple times, but their response has always been "it's not a high priority". After digging in their code, it's riddled with NOLOCK, and uses READ UNCOMMITTED SNAPSHOT when they can't NOLOCK it (and then they NOLOCK the joins, whee!). Asked them if I could work with them to rewrite the NOLOCKs out, since the business has seen the negative side effects pretty regularly, and their general response was "it's our software, we wrote it this way, and if you don't like it, fine!". Slightly more verbose, but that was about it.
The unfortunate part of this is that we work in conjunction with several other agencies, and the software choice was basically passed down to us, so we don't really have a way out of it. I've been hired to get around some of it, like writing SSRS reports to replace their inefficient ones, but this particular case uses some logic that I can't quite crack. Maybe with a day or two of analyzing the structure, but it's a lot of joins between non-descriptive columns using criteria that don't have much tacit meaning.
Err... *Ahem*. Ok, ranting over :-P. Back to trying to get some method to work here! I might fume over it, but if I apply enough elbow grease, it should work eventually!
- 😀
September 26, 2013 at 2:59 pm
hisakimatama (9/26/2013)
SQLRNNR (9/26/2013)
hisakimatama (9/26/2013)
Aaaaaaargh... And now, I need to fume :-P.Working with the company's vendor software, and one of the reports is coming across super-slow, about 10 minutes to retrieve about 150 items. Caught the code with Profiler, and... It's got a DISTINCT on a list of fields that's about 30 items long. Pluck the DISTINCT out, and the code drops from 10 minutes to run to three seconds, with identical results in all test cases.
Sadly, the report query isn't being held in a proc in the database; it's being assembled in the ASP.net front-end, and run from there. As far as I know of, I can't reach in there and rip the offending bit out. Is there some way of handling this, or should I introduce my forehead to my desk a few times? 🙂
So, the report is also an ASP .Net page (doesn't reference an SSRS or Crystal type report)?
Either way, it's a perfect example of evidence to beat on the vendor about. Take the evidence to them and tell them to fix it.
Yep, the report's an ASP.Net page too; there's a SSRS report base in the software, but it's unused.
And poking the vendor about the issue... *Shudder*. This company's had issues with the software almost from day 1 for all kinds of reasons. Their search functions are SQL-injectable, and we've reported it multiple times, but their response has always been "it's not a high priority". After digging in their code, it's riddled with NOLOCK, and uses READ UNCOMMITTED SNAPSHOT when they can't NOLOCK it (and then they NOLOCK the joins, whee!). Asked them if I could work with them to rewrite the NOLOCKs out, since the business has seen the negative side effects pretty regularly, and their general response was "it's our software, we wrote it this way, and if you don't like it, fine!". Slightly more verbose, but that was about it.
The unfortunate part of this is that we work in conjunction with several other agencies, and the software choice was basically passed down to us, so we don't really have a way out of it. I've been hired to get around some of it, like writing SSRS reports to replace their inefficient ones, but this particular case uses some logic that I can't quite crack. Maybe with a day or two of analyzing the structure, but it's a lot of joins between non-descriptive columns using criteria that don't have much tacit meaning.
Err... *Ahem*. Ok, ranting over :-P. Back to trying to get some method to work here! I might fume over it, but if I apply enough elbow grease, it should work eventually!
Vendors are awesome.
We love vendors.
They do so many screwy things and they care so little about anything more than making a buck. There are only a handful of vendors that don't fall into this kind of category, but most fit the profile.
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
September 26, 2013 at 3:02 pm
SQLRNNR (9/26/2013)
Vendors are awesome.
We love vendors.
I think it depends on how they're cooked.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 26, 2013 at 3:08 pm
The Dixie Flatline (9/26/2013)
SQLRNNR (9/26/2013)
Vendors are awesome.
We love vendors.
I think it depends on how they're cooked.
a little spice, smoke, and slow cook em for a couple of days
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
September 26, 2013 at 5:12 pm
Lynn Pettis (9/26/2013)
I know most Threadizens know I am currently deployed in Afghanistan as a civilian contractor.I was notified this evening that my position state side has been cut as part of company layoff. Unlike my fellow workers state side whose last day of employment is tomorrow, I still have a job here in Afghanistan. What I don't have is a job to come home to now. It looks like I will also be extending out here until February 2014 at this time as well (Yea me!! And yes, I am excited about this).
What this means is I am reaching out to start my job search now while I am still working. Yes, I would like to stay out here as long as possible. The money is really good and offers me the opportunity to put money aside should I come home to a continuing job search.
I will be reworking my resume over the next week or so. I would like to stay in the Colorado Springs area as I still have a daughter in High School (she is a sophomore now).
I telecommute position would be ideal.
With this news, I have some other news.
My ex-wife and I are getting back together. Yes, we are giving reconciliation a try. This deployment to Afghanistan opened a door and we both stepped through.
For me it started when she and my youngest daughter took me to the airport to start my journey to Afghanistan. She started to cry as we said good bye at the airport. I couldn't stop myself from telling her I loved her.
We have talked openly almost every day since then. It has been a blessed journey for me, and a confusing one for her.
It was during our talks I found out it started for her the night before I left while she was fixing my going away dinner. I stayed at her (our) house that night having moved out of my apartment that day so she and Kylie could take me to the airport the following morning.
That's totally awesome news all the way around! I'm excited for you both!
--Jeff Moden
Change is inevitable... Change for the better is not.
September 26, 2013 at 5:13 pm
hisakimatama (9/26/2013)
Aaaaaaargh... And now, I need to fume :-P.Working with the company's vendor software, and one of the reports is coming across super-slow, about 10 minutes to retrieve about 150 items. Caught the code with Profiler, and... It's got a DISTINCT on a list of fields that's about 30 items long. Pluck the DISTINCT out, and the code drops from 10 minutes to run to three seconds, with identical results in all test cases.
Sadly, the report query isn't being held in a proc in the database; it's being assembled in the ASP.net front-end, and run from there. As far as I know of, I can't reach in there and rip the offending bit out. Is there some way of handling this, or should I introduce my forehead to my desk a few times? 🙂
Heh... and now you truly understand the need for high velocity pork chops. 😛
Like the others said... I love vendors.... I just can't cook and eat a whole one.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 26, 2013 at 5:22 pm
SQLRNNR (9/26/2013)
hisakimatama (9/26/2013)
SQLRNNR (9/26/2013)
hisakimatama (9/20/2013)
*Huff* *Wheeze* I... I did it! I managed to read the entirety of The Thread! That was... Interesting :-D. Been lurking around here, being generally amazed at the questions posted and everyone's unwavering insistence on being helpful despite the odds. The community here is great indeed.I may chime in here a bit here and there, if you all won't mind, and if the rollercoaster of subjects strikes my fancy. Hopefully I won't eat a high-velocity pork chop or two in the near future 🙂
Are you still sane?:-D:-D:-D
Well, after reading so many posts about kilts, pork chops, Cthulhu, DBCC TimeWarp, hamster poo, and considering my last post in the thread... Probably not :w00t:
Wow - I'd forgotten all about those lonely hamsters.
Wow!!!! He really DID read the whole bloody thread!
Ah, hampster poo.... the ultimate fuel for DBCC TIMEWARP. I'm currently engaged in a project to make hampster poo look like pork chops... to feed to vendors, of course. The only real problem I've run into is that I also have to use DBCC TIMEWARP so the smell doesn't get to their nose until after I've fed it to them. I just can't incorporate it into the triple banded Wrist Rocket yet. I might give up on using DBCC TIMEWARP for that. Instead, I may have figure out how to "pulley" the bands so that I might be able to add a 4th or even 5th band. That would give me a range increase where the poo chop would get there long before the smell. Think of it as a one-two punch. :hehe:
--Jeff Moden
Change is inevitable... Change for the better is not.
September 26, 2013 at 5:24 pm
Chad Crawford (9/25/2013)
The Dixie Flatline (9/24/2013)
I haven't launched an Estes rocket in almost 40 years, but why stop at potatoes? It strikes me that carrots would make excellent sabot rounds.My Star Trek acumen tells me that a sabot is a wooden shoe. I had to Google for the obviously more common definition, since I couldn't see you making shoes out of carrots. 🙂
You're absolutely correct... large summer squash are a whole lot more comfortable.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 26, 2013 at 5:27 pm
Steve Jones - SSC Editor (9/25/2013)
No need for a potato gun, lathe, or automation.If you need it peeled, find someone that deserves a little punishment. Kids are good for this, but the rogue developer who's introduced too many bugs works just as well. Deploy paring knife and well wishes.
If you want to hit something with a flying potato, throw it.
Thats how it started with pork chops until I burned out my rotator cuff... too many 3rd party vendors and developers.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 26, 2013 at 5:30 pm
Stefan Krzywicki (9/25/2013)
I always figured they were fired by a disc-gun-like device ...
Ooooooooo.... you've just given me an idea. Reminds me of a child-hood toy I had. I used it to fire table saw blades back then. It could easily be modified to handle frozen pork chops. Well done!
--Jeff Moden
Change is inevitable... Change for the better is not.
September 26, 2013 at 5:31 pm
SQLRNNR (9/26/2013)
The Dixie Flatline (9/26/2013)
SQLRNNR (9/26/2013)
Vendors are awesome.
We love vendors.
I think it depends on how they're cooked.
a little spice, smoke, and slow cook em for a couple of days
No, please, make it a couple of weeks. A couple of days isnt long enough for them to suffer. Or maybe make it a couple of years? A couple of millenia? Eternity?
Tom
Viewing 15 posts - 41,446 through 41,460 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply