April 11, 2018 at 11:19 am
jasona.work - Wednesday, April 11, 2018 11:14 AMSo what you're saying Steve, is that your wife needs a Deuce and a half?
Plenty of ground clearance, more than enough "oomph" under the hood to deal with snow, mud, small rivers, stubborn cattle, and slow cars, and then you can put it into 6x6 drive for the really tough spots...
😀I keep semi-joking about getting one to use in the winter instead of my car, but I don't think the HOA would appreciate one of these things being parked in my drive...
Now, the guys at the gate at work? They'd love it, but I think some people might complain about me taking up two parking spaces...
(Fun fact, in the state of Michigan, you don't need a special license to drive one of these brutes and they're completely street-legal, so getting plates is no different than any other car.)
LOL, no. My wife has a Ram 3500, so plenty of clearance, but doesn't want to drive that most of the time if she's not taking a horse along. Lots of her trips are her, the little dog, and some tools that fit in the Prius. However, it's too low to the ground if weather is slightly bad.
For bad weather, the 3500 does the job.
April 11, 2018 at 11:34 am
Ed Wagner - Wednesday, April 11, 2018 11:17 AMjasona.work - Wednesday, April 11, 2018 11:14 AMSteve Jones - SSC Editor - Wednesday, April 11, 2018 11:05 AMLuis Cazares - Wednesday, April 11, 2018 10:46 AMFor that size and considering that you want a hybrid, I'd check the Kia Niro. We're probably discarding it because it's the smaller one and for some weird reason, my wife thinks that we might be driving uphill offroad at some point in time. The warranties are also really attractive.EDIT: I must add that we're biased against Toyota. But that's just personal experience.
My wife has loved her two Prius' over the years, just wants more clearance and a better chance of moving in snow. That's the main Prius drawback for us.
I'll have to check out the Kia. At first glance, it seems pricier for nothing more, but I'll look.
Steve Jones - SSC Editor - Wednesday, April 11, 2018 11:05 AMAny we are definitely offroad. 0.5mi of gravel to our house, plus plenty more for my wife's clients.So what you're saying Steve, is that your wife needs a Deuce and a half?
Plenty of ground clearance, more than enough "oomph" under the hood to deal with snow, mud, small rivers, stubborn cattle, and slow cars, and then you can put it into 6x6 drive for the really tough spots...
😀I keep semi-joking about getting one to use in the winter instead of my car, but I don't think the HOA would appreciate one of these things being parked in my drive...
Now, the guys at the gate at work? They'd love it, but I think some people might complain about me taking up two parking spaces...
(Fun fact, in the state of Michigan, you don't need a special license to drive one of these brutes and they're completely street-legal, so getting plates is no different than any other car.)I believe that the registration cost is based on the cost of the vehicle now, so there would be one slight difference every year. Then again, if you can afford one, you probably won't have to worry about the registration and plate fees. 😛
Believe it or not, you can get these brutes surplus for in the mid-$20s. All of the ones I've seen in that range have been running and (at least in the online listing pics) good condition...
But, the lack of a hard top, windows, creature comforts, canvas seats, loud enough you want to wear hearing protection, governor-limited to 55mph, kind of keeps me from actually buying one...
April 11, 2018 at 11:37 am
jasona.work - Wednesday, April 11, 2018 11:34 AMEd Wagner - Wednesday, April 11, 2018 11:17 AMjasona.work - Wednesday, April 11, 2018 11:14 AMSteve Jones - SSC Editor - Wednesday, April 11, 2018 11:05 AMLuis Cazares - Wednesday, April 11, 2018 10:46 AMFor that size and considering that you want a hybrid, I'd check the Kia Niro. We're probably discarding it because it's the smaller one and for some weird reason, my wife thinks that we might be driving uphill offroad at some point in time. The warranties are also really attractive.EDIT: I must add that we're biased against Toyota. But that's just personal experience.
My wife has loved her two Prius' over the years, just wants more clearance and a better chance of moving in snow. That's the main Prius drawback for us.
I'll have to check out the Kia. At first glance, it seems pricier for nothing more, but I'll look.
Steve Jones - SSC Editor - Wednesday, April 11, 2018 11:05 AMAny we are definitely offroad. 0.5mi of gravel to our house, plus plenty more for my wife's clients.So what you're saying Steve, is that your wife needs a Deuce and a half?
Plenty of ground clearance, more than enough "oomph" under the hood to deal with snow, mud, small rivers, stubborn cattle, and slow cars, and then you can put it into 6x6 drive for the really tough spots...
😀I keep semi-joking about getting one to use in the winter instead of my car, but I don't think the HOA would appreciate one of these things being parked in my drive...
Now, the guys at the gate at work? They'd love it, but I think some people might complain about me taking up two parking spaces...
(Fun fact, in the state of Michigan, you don't need a special license to drive one of these brutes and they're completely street-legal, so getting plates is no different than any other car.)I believe that the registration cost is based on the cost of the vehicle now, so there would be one slight difference every year. Then again, if you can afford one, you probably won't have to worry about the registration and plate fees. 😛
Believe it or not, you can get these brutes surplus for in the mid-$20s. All of the ones I've seen in that range have been running and (at least in the online listing pics) good condition...
But, the lack of a hard top, windows, creature comforts, canvas seats, loud enough you want to wear hearing protection, governor-limited to 55mph, kind of keeps me from actually buying one...
Is the governor-limited 55mph a legal requirement?
April 11, 2018 at 11:45 am
Lynn Pettis - Wednesday, April 11, 2018 11:37 AMjasona.work - Wednesday, April 11, 2018 11:34 AMEd Wagner - Wednesday, April 11, 2018 11:17 AMjasona.work - Wednesday, April 11, 2018 11:14 AMSteve Jones - SSC Editor - Wednesday, April 11, 2018 11:05 AMLuis Cazares - Wednesday, April 11, 2018 10:46 AMFor that size and considering that you want a hybrid, I'd check the Kia Niro. We're probably discarding it because it's the smaller one and for some weird reason, my wife thinks that we might be driving uphill offroad at some point in time. The warranties are also really attractive.EDIT: I must add that we're biased against Toyota. But that's just personal experience.
My wife has loved her two Prius' over the years, just wants more clearance and a better chance of moving in snow. That's the main Prius drawback for us.
I'll have to check out the Kia. At first glance, it seems pricier for nothing more, but I'll look.
Steve Jones - SSC Editor - Wednesday, April 11, 2018 11:05 AMAny we are definitely offroad. 0.5mi of gravel to our house, plus plenty more for my wife's clients.So what you're saying Steve, is that your wife needs a Deuce and a half?
Plenty of ground clearance, more than enough "oomph" under the hood to deal with snow, mud, small rivers, stubborn cattle, and slow cars, and then you can put it into 6x6 drive for the really tough spots...
😀I keep semi-joking about getting one to use in the winter instead of my car, but I don't think the HOA would appreciate one of these things being parked in my drive...
Now, the guys at the gate at work? They'd love it, but I think some people might complain about me taking up two parking spaces...
(Fun fact, in the state of Michigan, you don't need a special license to drive one of these brutes and they're completely street-legal, so getting plates is no different than any other car.)I believe that the registration cost is based on the cost of the vehicle now, so there would be one slight difference every year. Then again, if you can afford one, you probably won't have to worry about the registration and plate fees. 😛
Believe it or not, you can get these brutes surplus for in the mid-$20s. All of the ones I've seen in that range have been running and (at least in the online listing pics) good condition...
But, the lack of a hard top, windows, creature comforts, canvas seats, loud enough you want to wear hearing protection, governor-limited to 55mph, kind of keeps me from actually buying one...
Is the governor-limited 55mph a legal requirement?
No, the article I read a year or two back about a guy in Mich who owned one, indicated it was there when he bought it.
Had a big plate inside the cab warning the driver it was limited.
I'm fairly sure this is the article: Jalopnik
April 11, 2018 at 12:36 pm
Ed Wagner - Wednesday, April 11, 2018 11:06 AMSean Lange - Wednesday, April 11, 2018 10:27 AMWOW. The company who built our ERP apparently also created some ETL jobs for us on our BI server. There is an issue with one of those jobs that was handed to me today. This job has 316 steps. And every single job goes to step 316 on failure and inserts the exact same error "information". Seriously 316 steps??? And just the step I am working on is a single stored procedure that calls more than 40 others, and most of those calls others. And the naming conventions make me want to peel my eyeballs. Ed Wagner likely knows the kind of BS I am dealing with as he has worked this particular joy of an application before. See you guys next week or so once I start to unravel this monstrosity.Oh my. I've never worked with anything they created in SQL Server before, but I know their mentality in writing software defies reason and rational thought. If you think you'll be able to get it fully figured out in a week, it must be a simple one. I think it's called "rambo coding" in that they just keep pressing forward until it works one time through.
It's no wonder the company's been sold several times...the sellers couldn't maintain their software and the buyers didn't know what they were buying other than a sales worksheet. I've said it before, Sean, but I think it warrants saying again: I don't envy you in having to work with that particular product.
WOOT!!! I actually figured it out already. The logging pointed me to right step and then was able to fairly quickly isolate where in that step the problem was. It was process that truncates sales data and repopulates it from the beginning of time. Not the way I would build it for sure but too late for that. It was as simple as fixing an index to include two additional columns. Just doing a count for 380k rows took over an hour. Just a slight index tweak and it returns all the rows in under 2 minutes. It the longest running step of a nightly process that takes about 2 hours start to finish. I am guessing that time will dramatically reduced now.
_______________________________________________________________
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/
April 11, 2018 at 12:40 pm
Luis Cazares - Wednesday, April 11, 2018 10:36 AMjasona.work - Wednesday, April 11, 2018 10:22 AMLuis Cazares - Wednesday, April 11, 2018 6:52 AMI have no musical ability, but I learned some piano and french horn. I can remember some of the piano, but won't recommend to be around if I try to play the french horn again. 😀On a different note, we're struggli
ng to make a decision on which car to buy. We have four finalists:
Kia Niro
Honda CR-V
VW Tiguan
Subaru ForesterI can't decide what should be the deciding factor as all have advantages and disadvantages.
You know, if you want something rugged, reliable, that can go just about anywhere and still haul a lot of stuff, you can't go wrong with one of these:
M35A2 Deuce and a halfI prefer to get something that won't get me shot if I try to take it to Mexico.
Then you want one of these... OK, I want one.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 11, 2018 at 12:57 pm
Sean Lange - Wednesday, April 11, 2018 12:36 PMEd Wagner - Wednesday, April 11, 2018 11:06 AMSean Lange - Wednesday, April 11, 2018 10:27 AMWOW. The company who built our ERP apparently also created some ETL jobs for us on our BI server. There is an issue with one of those jobs that was handed to me today. This job has 316 steps. And every single job goes to step 316 on failure and inserts the exact same error "information". Seriously 316 steps??? And just the step I am working on is a single stored procedure that calls more than 40 others, and most of those calls others. And the naming conventions make me want to peel my eyeballs. Ed Wagner likely knows the kind of BS I am dealing with as he has worked this particular joy of an application before. See you guys next week or so once I start to unravel this monstrosity.Oh my. I've never worked with anything they created in SQL Server before, but I know their mentality in writing software defies reason and rational thought. If you think you'll be able to get it fully figured out in a week, it must be a simple one. I think it's called "rambo coding" in that they just keep pressing forward until it works one time through.
It's no wonder the company's been sold several times...the sellers couldn't maintain their software and the buyers didn't know what they were buying other than a sales worksheet. I've said it before, Sean, but I think it warrants saying again: I don't envy you in having to work with that particular product.
WOOT!!! I actually figured it out already. The logging pointed me to right step and then was able to fairly quickly isolate where in that step the problem was. It was process that truncates sales data and repopulates it from the beginning of time. Not the way I would build it for sure but too late for that. It was as simple as fixing an index to include two additional columns. Just doing a count for 380k rows took over an hour. Just a slight index tweak and it returns all the rows in under 2 minutes. It the longest running step of a nightly process that takes about 2 hours start to finish. I am guessing that time will dramatically reduced now.
Now that I understand. Years ago, I had to create a reporting warehouse structure from the b@@n tables because the native tables were too unruly and poorly-behaved to be used. They were also imprevious to indexing and the application never altered a table...they always exported the data, dropped the table, recreated the table and imported the data.
The original build took about 30 hours to run, which was unfortunate because the job had to run every day for executive reporting during the day. I was able to get it down to under 1/2 hour. It was difficult to do at the time (I was pretty green) but I learned an awful lot about query tuning and how tables work. I think that was one of those pivotal assignments that made me see things differently.
From your solution, I wonder if they overcame their problem with not allowing any indexing that wasn't created in the development environment.
April 11, 2018 at 1:00 pm
Grant Fritchey - Wednesday, April 11, 2018 12:40 PMLuis Cazares - Wednesday, April 11, 2018 10:36 AMjasona.work - Wednesday, April 11, 2018 10:22 AMYou know, if you want something rugged, reliable, that can go just about anywhere and still haul a lot of stuff, you can't go wrong with one of these:
M35A2 Deuce and a halfI prefer to get something that won't get me shot if I try to take it to Mexico.
Then you want one of these... OK, I want one.
Yeah, still a bad idea.
April 12, 2018 at 2:02 am
Steve Jones - SSC Editor - Wednesday, April 11, 2018 11:05 AMLuis Cazares - Wednesday, April 11, 2018 10:46 AMFor that size and considering that you want a hybrid, I'd check the Kia Niro. We're probably discarding it because it's the smaller one and for some weird reason, my wife thinks that we might be driving uphill offroad at some point in time. The warranties are also really attractive.EDIT: I must add that we're biased against Toyota. But that's just personal experience.
My wife has loved her two Prius' over the years, just wants more clearance and a better chance of moving in snow. That's the main Prius drawback for us.
I'll have to check out the Kia. At first glance, it seems pricier for nothing more, but I'll look.
Outlander PHEV?
Don't know if available in US yet.
Far away is close at hand in the images of elsewhere.
Anon.
April 12, 2018 at 6:46 am
If you're on the eastern seaboard of the US and you hear a grinding noise, it's just my teeth.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 12, 2018 at 8:32 am
David Burrows - Thursday, April 12, 2018 2:02 AMSteve Jones - SSC Editor - Wednesday, April 11, 2018 11:05 AMLuis Cazares - Wednesday, April 11, 2018 10:46 AMFor that size and considering that you want a hybrid, I'd check the Kia Niro. We're probably discarding it because it's the smaller one and for some weird reason, my wife thinks that we might be driving uphill offroad at some point in time. The warranties are also really attractive.EDIT: I must add that we're biased against Toyota. But that's just personal experience.
My wife has loved her two Prius' over the years, just wants more clearance and a better chance of moving in snow. That's the main Prius drawback for us.
I'll have to check out the Kia. At first glance, it seems pricier for nothing more, but I'll look.
Outlander PHEV?
Don't know if available in US yet.
I think they are, I may have been behind one last night.
April 12, 2018 at 10:13 am
Grant Fritchey - Thursday, April 12, 2018 6:46 AMIf you're on the eastern seaboard of the US and you hear a grinding noise, it's just my teeth.
I'm very tempted to post and tell the OP to restart the service, maybe install the latest service pack, just to mess with you/them further, but I'll be good. Today.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
April 12, 2018 at 10:15 am
jonathan.crawford - Thursday, April 12, 2018 10:13 AMGrant Fritchey - Thursday, April 12, 2018 6:46 AMIf you're on the eastern seaboard of the US and you hear a grinding noise, it's just my teeth.I'm very tempted to post and tell the OP to restart the service, maybe install the latest service pack, just to mess with you/them further, but I'll be good. Today.
What about reinstalling the OS or upgrading to the latest version? :hehe:
April 12, 2018 at 10:21 am
Luis Cazares - Thursday, April 12, 2018 10:15 AMjonathan.crawford - Thursday, April 12, 2018 10:13 AMGrant Fritchey - Thursday, April 12, 2018 6:46 AMIf you're on the eastern seaboard of the US and you hear a grinding noise, it's just my teeth.I'm very tempted to post and tell the OP to restart the service, maybe install the latest service pack, just to mess with you/them further, but I'll be good. Today.
What about reinstalling the OS or upgrading to the latest version? :hehe:
Solid bet, they're not on the latest CU and are probably on RTM. Not that it will help.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 12, 2018 at 11:01 pm
We just had Paul Randal give our user group his famous Index Fragmentation lecture. The man is one hell of a great teacher. I hope he never loses his passion for teaching.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 15 posts - 61,351 through 61,365 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply