Post reply

Are the posted questions getting worse?

  • February 16, 2012 at 4:44 pm

    #1448230

    GilaMonster (2/16/2012)

    SQL Kiwi (2/16/2012)

    Are the posted articles[/url] getting worse?

    Dunno about worse, but definitely shorter

    Hit and miss, and this one was short. We have some long ones coming at times.

    It's a solution, and one that someone found worthwhile. If we are only going to publish the best solution for every problem, I think, well, that's impossible.

  • February 17, 2012 at 2:38 am

    #1448341

    Steve Jones - SSC Editor (2/14/2012)

    Steve Jones - SSC Editor (2/14/2012)

    Jeff Moden (2/13/2012)

    Shifting gears, I was going through the posts from "Posts added today" and there had to be two dozen posts from "Site Owners" that took us to some bloody blog post that we can't even leave a comment on SSC about. While it's nice to have access to such posts, they shouldn't show up in "Posts added today" because they aren't posts. They just clutter up the screen and make it more difficult to find people who have actual questions. Since we can't actually leave comments on SSC about these "posts", can you treat them more like "remote articles" and not have them show up in things like "Posts added today"?

    Dev is looking at this today. Not sure what he did, but hopefully will be fixed this week.

    We think this is fixed. We'll keep an eye out for this.

    Still happening. Not sure if it's as much, will see this weekend.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 17, 2012 at 5:51 am

    #1448432

    Koen Verbeeck (2/16/2012)

    The coldest was about -20 celsius at night and -12 celsius during the day. I once spent 25 minutes trying to start my car so I could get to work. (stupid American car :-P)

    Try synthetic oil.

    Or start a small fire under the oil pan.......

    Carefu with that one.:w00t:

  • February 17, 2012 at 6:50 am

    #1448466

    Revenant (2/16/2012)

    bitbucket-25253 (2/16/2012)

    Hye hey I drive a desil turbo changed Mercedes ... madie in Germany - try starting that one in the Cleveland area ... had a block heater installed so have to plug it in each night if I want to get going in the AM

    You can use the WWII-vintage method of draining the oil from the engine every night, keeping it indoors, heating it in the morning, pouring it back in and keeping the engine running all day. 😉

    My grandfather's diesel truck used to have a cutoff switch that bypassed the filters for when it was cold, because it gets too thick. Not sure exactly how that worked, but it was a solution for him.

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • February 17, 2012 at 7:27 am

    #1448492

    jcrawf02 (2/17/2012)

    Revenant (2/16/2012)

    bitbucket-25253 (2/16/2012)

    Hye hey I drive a desil turbo changed Mercedes ... madie in Germany - try starting that one in the Cleveland area ... had a block heater installed so have to plug it in each night if I want to get going in the AM

    You can use the WWII-vintage method of draining the oil from the engine every night, keeping it indoors, heating it in the morning, pouring it back in and keeping the engine running all day. 😉

    My grandfather's diesel truck used to have a cutoff switch that bypassed the filters for when it was cold, because it gets too thick. Not sure exactly how that worked, but it was a solution for him.

    Hope the fuel is clean.

    Injector pumps are very expensive.

    Had a VW pickup with a diesel, and put a kit on it.

    Small 12v heating pad which wrapped around the filter.

    Worked good, even at -25F.

  • February 17, 2012 at 7:58 am

    #1448528

    Greg Edwards-268690 (2/17/2012)

    Koen Verbeeck (2/16/2012)

    The coldest was about -20 celsius at night and -12 celsius during the day. I once spent 25 minutes trying to start my car so I could get to work. (stupid American car :-P)

    Try synthetic oil.

    Or start a small fire under the oil pan.......

    Carefu with that one.:w00t:

    I've done the thing with a lightbulb under the hood, when the car's in the garage. A 100W bulb provides enough heat to keep the oil and fuel from having problems, even in -35F (about -37C). It's a common solution, and doesn't have the fire risk you were joking about.

    Of course, has to be incandescent, not CFL or LED. I guess halogen would work, since those get hot, but haven't tried it.

    Also had an old Volkswagen Beetle that we put through four or five years of -35F to -45F winters, parked in the woods (where we lived), and we started that with no special tricks or anything. Worked great. But those were originally designed for the Autobahns that were going to be built across Siberia once Germany conquered the USSR in WW II. That didn't exactly work out as planned, but the cars did deal with extreme cold quite well. Note that air cooling was a critical part of that, because even pure glycol will freeze at those temperatures. Not sure how the cold oil problem or cold gas problem was handled, or if it even came up.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • February 17, 2012 at 9:05 am

    #1448592

    GSquared (2/17/2012)

    Also had an old Volkswagen Beetle that we put through four or five years of -35F to -45F winters, parked in the woods (where we lived), and we started that with no special tricks or anything. Worked great. But those were originally designed for the Autobahns that were going to be built across Siberia once Germany conquered the USSR in WW II. That didn't exactly work out as planned, but the cars did deal with extreme cold quite well. Note that air cooling was a critical part of that, because even pure glycol will freeze at those temperatures. Not sure how the cold oil problem or cold gas problem was handled, or if it even came up.

    I grew up with VW Beetles and Vans. I'll tell you what, air cooled with no gas heater (some don't have gas heaters), and my dad was driving with one hand on the wheel and the other scraping the frost off the window. No joke....

    You didn't take long trips back then. 🙂

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • February 17, 2012 at 9:31 am

    #1448606

    David Benoit (2/17/2012)

    GSquared (2/17/2012)

    Also had an old Volkswagen Beetle that we put through four or five years of -35F to -45F winters, parked in the woods (where we lived), and we started that with no special tricks or anything. Worked great. But those were originally designed for the Autobahns that were going to be built across Siberia once Germany conquered the USSR in WW II. That didn't exactly work out as planned, but the cars did deal with extreme cold quite well. Note that air cooling was a critical part of that, because even pure glycol will freeze at those temperatures. Not sure how the cold oil problem or cold gas problem was handled, or if it even came up.

    I grew up with VW Beetles and Vans. I'll tell you what, air cooled with no gas heater (some don't have gas heaters), and my dad was driving with one hand on the wheel and the other scraping the frost off the window. No joke....

    You didn't take long trips back then. 🙂

    Ours had the opposite problem. The hot air vents were near the passengers' feet in the back seat (bug), and would get so hot they actually melted the soles of our boots and scortched the leather a bit. We'd have to pull our feet up onto the seat to avoid burns. It was pulling hot air off the engine block, and it was insane how hot that was.

    Not sure how well it worked on the windshields. We would scrape those and then spray antifreeze on them. They got warm enough to keep reasonably pure glycol liquid, and water never had a chance to bind to the glass in that state. I think there may also have been some sort of silicone oil that we had to spray on when it got "that cold", but I don't remember the specifics on that (was about 30 years ago). So heat on the windshield wasn't an issue, nor was lack of it.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • February 17, 2012 at 10:59 am

    #1448663

    Getting away from cold weather and all, I can remember back to 1950 when an uncle of mine gave me his old, old beetle so it must have been say a 1940s model. Gas engine, no problem starting it, just pull the engine choke out all the way. Turn key to start, hear it grind, back fire a few times, and then purr like a kitten. Had to be very careful to push the choke back in slowly or it would eventually sputter to a stop. So much for the cold weather driving, but that beetle had a lever on the floor, just forward of the shift lever. Saved my butt more than once, engine sputtering to a halt for lack of gas. Turn that lever to open and wonderful ... allowed the fuel pump access to an additional supply of gas. Kept me from being run over by following vehicles. But of course every solution, has a problem, the engine would speed up almost instantly and my being short I had to duck down to reach that blankly, blank lever, so could not be looking out the window...thankfully I would have dropped back from the car I was following.... needless to say... my hair began to turn grey at an early age.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • February 17, 2012 at 11:17 am

    #1448682

    bitbucket-25253 (2/17/2012)

    Getting away from cold weather and all, I can remember back to 1950 when an uncle of mine gave me his old, old beetle so it must have been say a 1940s model. Gas engine, no problem starting it, just pull the engine choke out all the way. Turn key to start, hear it grind, back fire a few times, and then purr like a kitten. Had to be very careful to push the choke back in slowly or it would eventually sputter to a stop. So much for the cold weather driving, but that beetle had a lever on the floor, just forward of the shift lever. Saved my butt more than once, engine sputtering to a halt for lack of gas. Turn that lever to open and wonderful ... allowed the fuel pump access to an additional supply of gas. Kept me from being run over by following vehicles. But of course every solution, has a problem, the engine would speed up almost instantly and my being short I had to duck down to reach that blankly, blank lever, so could not be looking out the window...thankfully I would have dropped back from the car I was following.... needless to say... my hair began to turn grey at an early age.

    We had the same throttle/choke, and reserve tank on ours. My worst memories on learning to drive were trying to figure out how to start on a steep hill, going up, from parallel parking. Had to handle the throttle, the clutch, the brake, the gas, the gear-stick, and steer the car, without stalling, crashing into the car ahead of or behind me, lugging the engine, grinding the gears, or lurching hard enough to knock teeth out on the steering wheel. I'm not dextrous enough for all of that, never have been.

    (Now I drive something with an automatic transmission, power steering and brakes, et al. Next upgrade in that tech should be something that'll drive itself better than I ever will.)

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • February 17, 2012 at 11:38 am

    #1448702

    GSquared (2/17/2012)

    bitbucket-25253 (2/17/2012)

    Getting away from cold weather and all, I can remember back to 1950 when an uncle of mine gave me his old, old beetle so it must have been say a 1940s model. Gas engine, no problem starting it, just pull the engine choke out all the way. Turn key to start, hear it grind, back fire a few times, and then purr like a kitten. Had to be very careful to push the choke back in slowly or it would eventually sputter to a stop. So much for the cold weather driving, but that beetle had a lever on the floor, just forward of the shift lever. Saved my butt more than once, engine sputtering to a halt for lack of gas. Turn that lever to open and wonderful ... allowed the fuel pump access to an additional supply of gas. Kept me from being run over by following vehicles. But of course every solution, has a problem, the engine would speed up almost instantly and my being short I had to duck down to reach that blankly, blank lever, so could not be looking out the window...thankfully I would have dropped back from the car I was following.... needless to say... my hair began to turn grey at an early age.

    We had the same throttle/choke, and reserve tank on ours. My worst memories on learning to drive were trying to figure out how to start on a steep hill, going up, from parallel parking. Had to handle the throttle, the clutch, the brake, the gas, the gear-stick, and steer the car, without stalling, crashing into the car ahead of or behind me, lugging the engine, grinding the gears, or lurching hard enough to knock teeth out on the steering wheel. I'm not dextrous enough for all of that, never have been.

    (Now I drive something with an automatic transmission, power steering and brakes, et al. Next upgrade in that tech should be something that'll drive itself better than I ever will.)

    BMW, Toyota an Volkwagen are workinjg on it.

    http://www.youtube.com/watch?v=KfUBTOTp2Fw

  • February 17, 2012 at 11:43 am

    #1448705

    Hey guys, I'm having trouble getting minimal logging with BULK to work via T-SQL. Can anyone who's more familiar give me a hand here: http://www.sqlservercentral.com/Forums/Topic1253552-338-1.aspx

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • February 17, 2012 at 11:48 am

    #1448710

    Revenant (2/17/2012)

    GSquared (2/17/2012)

    bitbucket-25253 (2/17/2012)

    Getting away from cold weather and all, I can remember back to 1950 when an uncle of mine gave me his old, old beetle so it must have been say a 1940s model. Gas engine, no problem starting it, just pull the engine choke out all the way. Turn key to start, hear it grind, back fire a few times, and then purr like a kitten. Had to be very careful to push the choke back in slowly or it would eventually sputter to a stop. So much for the cold weather driving, but that beetle had a lever on the floor, just forward of the shift lever. Saved my butt more than once, engine sputtering to a halt for lack of gas. Turn that lever to open and wonderful ... allowed the fuel pump access to an additional supply of gas. Kept me from being run over by following vehicles. But of course every solution, has a problem, the engine would speed up almost instantly and my being short I had to duck down to reach that blankly, blank lever, so could not be looking out the wwindow...thankfully I would have dropped back from the car I was following.... needless to say... my hair began to turn grey at an early age.

    We had the same throttle/choke, and reserve tank on ours. My worst memories on learning to drive were trying to figure out how to start on a steep hill, going up, from parallel parking. Had to handle the throttle, the clutch, the brake, the gas, the gear-stick, and steer the car, without stalling, crashing into the car ahead of or behind me, lugging the engine, grinding the gears, or lurching hard enough to knock teeth out on the steering wheel. I'm not dextrous enough for all of that, never have been.

    (Now I drive something with an automatic transmission, power steering and brakes, et al. Next upgrade in that tech should be something that'll drive itself better than I ever will.)

    BMW, Toyota an Volkwagen are workinjg on it.

    http://www.youtube.com/watch?v=KfUBTOTp2Fw

    Way way back Virginia Tech was working on a system with a buried cable in each lane, a sensing mechanism on the front of your can, automatic steering / throttle controls so you could pick a lane, fall asleep and your car would safely continue on .... But alas and alack they could never get the system to work 100 percent perfect and the cost of burying those cables in each road, even just interstate limited access highways, would make today's national debt look small

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • February 17, 2012 at 11:50 am

    #1448711

    bitbucket-25253 (2/17/2012)

    Revenant (2/17/2012)

    GSquared (2/17/2012)

    bitbucket-25253 (2/17/2012)

    Getting away from cold weather and all, I can remember back to 1950 when an uncle of mine gave me his old, old beetle so it must have been say a 1940s model. Gas engine, no problem starting it, just pull the engine choke out all the way. Turn key to start, hear it grind, back fire a few times, and then purr like a kitten. Had to be very careful to push the choke back in slowly or it would eventually sputter to a stop. So much for the cold weather driving, but that beetle had a lever on the floor, just forward of the shift lever. Saved my butt more than once, engine sputtering to a halt for lack of gas. Turn that lever to open and wonderful ... allowed the fuel pump access to an additional supply of gas. Kept me from being run over by following vehicles. But of course every solution, has a problem, the engine would speed up almost instantly and my being short I had to duck down to reach that blankly, blank lever, so could not be looking out the wwindow...thankfully I would have dropped back from the car I was following.... needless to say... my hair began to turn grey at an early age.

    We had the same throttle/choke, and reserve tank on ours. My worst memories on learning to drive were trying to figure out how to start on a steep hill, going up, from parallel parking. Had to handle the throttle, the clutch, the brake, the gas, the gear-stick, and steer the car, without stalling, crashing into the car ahead of or behind me, lugging the engine, grinding the gears, or lurching hard enough to knock teeth out on the steering wheel. I'm not dextrous enough for all of that, never have been.

    (Now I drive something with an automatic transmission, power steering and brakes, et al. Next upgrade in that tech should be something that'll drive itself better than I ever will.)

    BMW, Toyota an Volkwagen are workinjg on it.

    http://www.youtube.com/watch?v=KfUBTOTp2Fw

    Way way back Virginia Tech was working on a system with a buried cable in each lane, a sensing mechanism on the front of your can, automatic steering / throttle controls so you could pick a lane, fall asleep and your car would safely continue on .... But alas and alack they could never get the system to work 100 percent perfect and the cost of burying those cables in each road, even just interstate limited access highways, would make today's national debt look small

    And heaven forbid a minor earthquake or some such cut the cable and killed thousands of drivers.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • February 17, 2012 at 12:16 pm

    #1448727

    GSquared (2/17/2012)

    bitbucket-25253 (2/17/2012)

    Way way back Virginia Tech was working on a system with a buried cable in each lane, a sensing mechanism on the front of your can, automatic steering / throttle controls so you could pick a lane, fall asleep and your car would safely continue on .... But alas and alack they could never get the system to work 100 percent perfect and the cost of burying those cables in each road, even just interstate limited access highways, would make today's national debt look small

    And heaven forbid a minor earthquake or some such cut the cable and killed thousands of drivers.

    There's another version out there that detects lanes via the pain lines/reflectors and uses collision detection to determine its speed.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

Viewing 15 posts - 34,351 through 34,365 (of 66,712 total)

You must be logged in to reply to this topic. Login to reply