Are the posted questions getting worse?

  • Brandie Tarvin - Wednesday, January 3, 2018 9:34 AM

    We don't turn off our AC until about mid-December and then it's back on by the end of February. Our attic traps a lot of heat.

    Hehe not this year. I was in Orlando in early December. We were in the pool on December 8th and the next day it was really chilly. We had to wear hoodies our entire time at Disney and it wasn't really enough clothing most of the time but I wasn't buying jackets for four people at Disney either. We just had to walk faster. πŸ˜›

    _______________________________________________________________

    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/

  • Sean Lange - Wednesday, January 3, 2018 10:01 AM

    Brandie Tarvin - Wednesday, January 3, 2018 9:34 AM

    We don't turn off our AC until about mid-December and then it's back on by the end of February. Our attic traps a lot of heat.

    Hehe not this year. I was in Orlando in early December. We were in the pool on December 8th and the next day it was really chilly. We had to wear hoodies our entire time at Disney and it wasn't really enough clothing most of the time but I wasn't buying jackets for four people at Disney either. We just had to walk faster. πŸ˜›

    I suppose it might have meant that the park was a little quieter at least? I'm sure there were people that were less inclined to go to Disney as it was a little chilly outside. πŸ™‚

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • Just spent a business day prototyping a partition-switch mechanism to improve the performance of a weekly data feed of 50M rows into a 12,000,000,000 row table. It takes ten hours. Most of this time is rebuilding the indexes, which they disable before the load. The process duration of the new mechanism is under ten minutes, two minutes of which is rebuilding the indexes in the switch table.
    "Do you want some help implementing this?" "No thanks. It happens on Saturdays. We'll get around to it."
    The existing process has failed for the last four Saturdays, io timeouts.
    I'll get me coat.

    β€œWrite the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

  • jasona.work - Wednesday, January 3, 2018 8:55 AM

    Brandie Tarvin - Wednesday, January 3, 2018 3:19 AM

    Does anyone feel sorry for me yet?

    https://weather.com/weather/today/l/USFL0228:1:US

    Bridges are supposed to start freezing sometime soon.

    Sorry, my "feel sorry" gland has frozen solid today:
    http://forecast.weather.gov/MapClick.php?lat=42.61204000000009&lon=-82.96807999999998#.Wkz8Z7AUl7g
    πŸ™‚
    My car *JUST* starts warming up by the time I get home or get to work, I'm just happy tomorrow I work from home...
    Although, tomorrow afternoon I've got to go to clean out some trash from a garage (unheated, of course,) so that's going to be...
    Fun...

    20 below and you might be amazed at some new sounds your car can make.
    Enough ice to start driving out to go fishing. And finally warm enough that the beer is slushy, not frozen solid.

    Has to be tough in Florida - snow down there is bad, but a coating of ice too - ouch!
    Even if you know how to drive in the stuff, you will be likely surrounded by the clueless.
    Good day to work from home if that's an option.

  • Brandie Tarvin - Wednesday, January 3, 2018 9:34 AM

    We don't turn off our AC until about mid-December and then it's back on by the end of February. Our attic traps a lot of heat.

    A properly installed attic fan will save you oodles on air conditioning,.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • Greg Edwards-268690 - Wednesday, January 3, 2018 10:16 AM

    jasona.work - Wednesday, January 3, 2018 8:55 AM

    Brandie Tarvin - Wednesday, January 3, 2018 3:19 AM

    Does anyone feel sorry for me yet?

    https://weather.com/weather/today/l/USFL0228:1:US

    Bridges are supposed to start freezing sometime soon.

    Sorry, my "feel sorry" gland has frozen solid today:
    http://forecast.weather.gov/MapClick.php?lat=42.61204000000009&lon=-82.96807999999998#.Wkz8Z7AUl7g
    πŸ™‚
    My car *JUST* starts warming up by the time I get home or get to work, I'm just happy tomorrow I work from home...
    Although, tomorrow afternoon I've got to go to clean out some trash from a garage (unheated, of course,) so that's going to be...
    Fun...

    20 below and you might be amazed at some new sounds your car can make.
    Enough ice to start driving out to go fishing. And finally warm enough that the beer is slushy, not frozen solid.

    Has to be tough in Florida - snow down there is bad, but a coating of ice too - ouch!
    Even if you know how to drive in the stuff, you will be likely surrounded by the clueless.
    Good day to work from home if that's an option.

    The worst thing right now is, I think I might need a new battery, the car is NOT enjoying itself when I go to start it...

    I recall a story from many years back, of a northern transplant to Atlanta.  It was his turn to drive the carpool, after it had snowed the night before (maybe an inch or less.)  Gets to the first house, the passenger comes out in their PJs and robe asking what the heck he was doing there, that it had snowed and the whole city was shut down.

    As for driving in this stuff, even around here (Detroit) it seems like people forget how to drive in snow over the summer, and some don't ever seem to remember how...

  • jasona.work - Wednesday, January 3, 2018 10:34 AM

    Greg Edwards-268690 - Wednesday, January 3, 2018 10:16 AM

    jasona.work - Wednesday, January 3, 2018 8:55 AM

    Brandie Tarvin - Wednesday, January 3, 2018 3:19 AM

    Does anyone feel sorry for me yet?

    https://weather.com/weather/today/l/USFL0228:1:US

    Bridges are supposed to start freezing sometime soon.

    Sorry, my "feel sorry" gland has frozen solid today:
    http://forecast.weather.gov/MapClick.php?lat=42.61204000000009&lon=-82.96807999999998#.Wkz8Z7AUl7g
    πŸ™‚
    My car *JUST* starts warming up by the time I get home or get to work, I'm just happy tomorrow I work from home...
    Although, tomorrow afternoon I've got to go to clean out some trash from a garage (unheated, of course,) so that's going to be...
    Fun...

    20 below and you might be amazed at some new sounds your car can make.
    Enough ice to start driving out to go fishing. And finally warm enough that the beer is slushy, not frozen solid.

    Has to be tough in Florida - snow down there is bad, but a coating of ice too - ouch!
    Even if you know how to drive in the stuff, you will be likely surrounded by the clueless.
    Good day to work from home if that's an option.

    The worst thing right now is, I think I might need a new battery, the car is NOT enjoying itself when I go to start it...

    I recall a story from many years back, of a northern transplant to Atlanta.  It was his turn to drive the carpool, after it had snowed the night before (maybe an inch or less.)  Gets to the first house, the passenger comes out in their PJs and robe asking what the heck he was doing there, that it had snowed and the whole city was shut down.

    As for driving in this stuff, even around here (Detroit) it seems like people forget how to drive in snow over the summer, and some don't ever seem to remember how...

    Get that snow amnesia here in Colorado as well.  Sometimes it happens between snow storms since the snow doesn't hang around long most of the time in the city.

  • Here is one for you all:
    http://www.theregister.co.uk/2018/01/02/intel_cpu_design_flaw/

  • grant@scarydba.com - Wednesday, January 3, 2018 4:52 AM

    Brandie Tarvin - Wednesday, January 3, 2018 3:19 AM

    Does anyone feel sorry for me yet?

    https://weather.com/weather/today/l/USFL0228:1:US

    Bridges are supposed to start freezing sometime soon.

    Nope:
    https://weather.com/weather/today/l/USMA0429:1:US

    hey, high temperature here is going to be single digits next few days, I don't want to hear it  LOL πŸ˜›
    https://weather.com/weather/today/l/USOH0195:1:US

  • Lynn Pettis - Wednesday, January 3, 2018 11:00 AM

    Well that is interesting. Just days after a new build for my home computer. Sure am glad I ended up using and AMD Ryzen chip. πŸ™‚

    _______________________________________________________________

    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/

  • Jeff Moden - Wednesday, January 3, 2018 10:28 AM

    Brandie Tarvin - Wednesday, January 3, 2018 9:34 AM

    We don't turn off our AC until about mid-December and then it's back on by the end of February. Our attic traps a lot of heat.

    A properly installed attic fan will save you oodles on air conditioning,.

    Hah. We've got attic fans. The regular one and the super-special "in the garage draws 'cool' air from the outside into the attic" one the SO had installed a few years back.

    Guess what? Florida doesn't HAVE cool air during the spring / summer / fall.

    Of course, after the second fan was installed, the in-house temperature dropped by 4 degrees and the AC unit stopped working like a work-a-holic ready to have a coronary. So it did good for us.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • jasona.work - Wednesday, January 3, 2018 10:34 AM

    Greg Edwards-268690 - Wednesday, January 3, 2018 10:16 AM

    jasona.work - Wednesday, January 3, 2018 8:55 AM

    Brandie Tarvin - Wednesday, January 3, 2018 3:19 AM

    Does anyone feel sorry for me yet?

    https://weather.com/weather/today/l/USFL0228:1:US

    Bridges are supposed to start freezing sometime soon.

    Sorry, my "feel sorry" gland has frozen solid today:
    http://forecast.weather.gov/MapClick.php?lat=42.61204000000009&lon=-82.96807999999998#.Wkz8Z7AUl7g
    πŸ™‚
    My car *JUST* starts warming up by the time I get home or get to work, I'm just happy tomorrow I work from home...
    Although, tomorrow afternoon I've got to go to clean out some trash from a garage (unheated, of course,) so that's going to be...
    Fun...

    20 below and you might be amazed at some new sounds your car can make.
    Enough ice to start driving out to go fishing. And finally warm enough that the beer is slushy, not frozen solid.

    Has to be tough in Florida - snow down there is bad, but a coating of ice too - ouch!
    Even if you know how to drive in the stuff, you will be likely surrounded by the clueless.
    Good day to work from home if that's an option.

    The worst thing right now is, I think I might need a new battery, the car is NOT enjoying itself when I go to start it...

    I recall a story from many years back, of a northern transplant to Atlanta.  It was his turn to drive the carpool, after it had snowed the night before (maybe an inch or less.)  Gets to the first house, the passenger comes out in their PJs and robe asking what the heck he was doing there, that it had snowed and the whole city was shut down.

    As for driving in this stuff, even around here (Detroit) it seems like people forget how to drive in snow over the summer, and some don't ever seem to remember how...

    Heh... I find that some don't even know how to drive on bare asphalt in the summer.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • I remember the one time it snowed in South Carolina when I lived there. Only about 2 inches. Nobody, and I mean NOBODY, on the road as I drove to work. I had keys to the workplace, so let myself in, turned off the alarm, logged into all the systems and waited. No customers, no co-workers. No one until about 90 minutes later (who came in looking for snow plows of all things). Finally, about 2.5 hours later, the boss comes in and everyone else straggles in AFTER the snow had melted.

    Boss wanted to know what I was doing in so early. Me, I wanted to know what was so bad about 2 inches of snow that no one could make it in on time.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Jeff Moden - Wednesday, January 3, 2018 12:32 PM

    Heh... I find that some don't even know how to drive on bare asphalt in the summer.

    /Me thinks about driving the Southfield during rush hour, breaks into a cold sweat...

  • Brandie Tarvin - Wednesday, January 3, 2018 12:42 PM

    I remember the one time it snowed in South Carolina when I lived there. Only about 2 inches. Nobody, and I mean NOBODY, on the road as I drove to work. I had keys to the workplace, so let myself in, turned off the alarm, logged into all the systems and waited. No customers, no co-workers. No one until about 90 minutes later (who came in looking for snow plows of all things). Finally, about 2.5 hours later, the boss comes in and everyone else straggles in AFTER the snow had melted.

    Boss wanted to know what I was doing in so early. Me, I wanted to know what was so bad about 2 inches of snow that no one could make it in on time.

    Even better then would have been if you drove some sort of sports car.

Viewing 15 posts - 60,856 through 60,870 (of 66,000 total)

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