Are the posted questions getting worse?

  • WayneS (3/24/2016)


    ChrisM@Work (3/24/2016)


    Stage fright can hit anyone I suppose.

    Yes it does... even those that speak frequently. I know of a fellow threadizen that is a very frequent speaker, yet has stage fright prior to every presentation. It really surprised me when I was told this.

    Still gets me at times.

    Last year at PASS, new session, never practiced anywhere live. Spent most of the week in my hotel rehearsing demos.

  • Steve Jones - SSC Editor (3/24/2016)


    WayneS (3/24/2016)


    ChrisM@Work (3/24/2016)


    Stage fright can hit anyone I suppose.

    Yes it does... even those that speak frequently. I know of a fellow threadizen that is a very frequent speaker, yet has stage fright prior to every presentation. It really surprised me when I was told this.

    Still gets me at times.

    Last year at PASS, new session, never practiced anywhere live. Spent most of the week in my hotel rehearsing demos.

    I think that was me. I get nervous every time. I speak a lot, so that's a ton of nerves.

    "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

  • Grant Fritchey (3/24/2016)


    Steve Jones - SSC Editor (3/24/2016)


    WayneS (3/24/2016)


    ChrisM@Work (3/24/2016)


    Stage fright can hit anyone I suppose.

    Yes it does... even those that speak frequently. I know of a fellow threadizen that is a very frequent speaker, yet has stage fright prior to every presentation. It really surprised me when I was told this.

    Still gets me at times.

    Last year at PASS, new session, never practiced anywhere live. Spent most of the week in my hotel rehearsing demos.

    I think that was me. I get nervous every time. I speak a lot, so that's a ton of nerves.

    I'm ... stunned. Last year at SQL Bits I sneaked into one of your talks Grant and there you were with your a$$ perched on a desk corner, cool as a dad talking to a kid, except it was a roomful and a half of bat-eared geeks eager to pick up the latest stuff and you could have heard a hair drop.

    β€œ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

  • ChrisM@Work (3/24/2016)


    Grant Fritchey (3/24/2016)


    Steve Jones - SSC Editor (3/24/2016)


    WayneS (3/24/2016)


    ChrisM@Work (3/24/2016)


    Stage fright can hit anyone I suppose.

    Yes it does... even those that speak frequently. I know of a fellow threadizen that is a very frequent speaker, yet has stage fright prior to every presentation. It really surprised me when I was told this.

    Still gets me at times.

    Last year at PASS, new session, never practiced anywhere live. Spent most of the week in my hotel rehearsing demos.

    I think that was me. I get nervous every time. I speak a lot, so that's a ton of nerves.

    I'm ... stunned. Last year at SQL Bits I sneaked into one of your talks Grant and there you were with your a$$ perched on a desk corner, cool as a dad talking to a kid, except it was a roomful and a half of bat-eared geeks eager to pick up the latest stuff and you could have heard a hair drop.

    It's called putting on an act.

    The number of times I've given a presentation and had large numbers of positive comments, while it was the last place in the world I wanted to be and it had taken a huge amount of effort to just walk into the room and I hated every minute of the talk.

    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
  • Sean Lange (3/24/2016)


    Alan.B (3/24/2016)


    Brandie Tarvin (3/24/2016)


    <headdesk>

    One of my coworkers just came up with the worst joke ever.

    Three DBAs walk into a NoSQL bar. Soon after, they leave - they couldn't join a table!

    Will G.

    That's similar to the old joke:

    A DBA walks in to a bar, sees a set of tables, walks up to them and asks, "may I join you?"

    Sounds like a perfect UNION to me. :hehe:

    GROAN.

    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.

  • GilaMonster (3/24/2016)


    ChrisM@Work (3/24/2016)


    Grant Fritchey (3/24/2016)


    Steve Jones - SSC Editor (3/24/2016)


    WayneS (3/24/2016)


    ChrisM@Work (3/24/2016)


    Stage fright can hit anyone I suppose.

    Yes it does... even those that speak frequently. I know of a fellow threadizen that is a very frequent speaker, yet has stage fright prior to every presentation. It really surprised me when I was told this.

    Still gets me at times.

    Last year at PASS, new session, never practiced anywhere live. Spent most of the week in my hotel rehearsing demos.

    I think that was me. I get nervous every time. I speak a lot, so that's a ton of nerves.

    I'm ... stunned. Last year at SQL Bits I sneaked into one of your talks Grant and there you were with your a$$ perched on a desk corner, cool as a dad talking to a kid, except it was a roomful and a half of bat-eared geeks eager to pick up the latest stuff and you could have heard a hair drop.

    It's called putting on an act.

    The number of times I've given a presentation and had large numbers of positive comments, while it was the last place in the world I wanted to be and it had taken a huge amount of effort to just walk into the room and I hated every minute of the talk.

    Gail, I've never seen you speak in person.

    Grant, I have seen you and if you were nervous, you hid it very well.

    I must admit that it's a bit of a relief to know that I'm not the only one who gets nervous about it. I have nowhere near the experience that you both have, but I do find it gets easier each time. I'll eventually get to the point where it doesn't come with as much anxiety, but not all at once. Like anything worth doing, it takes time.

  • Luis Cazares (3/24/2016)


    Sean Lange (3/24/2016)


    ChrisM@Work (3/24/2016)


    Sean Lange (3/24/2016)


    --I posted in another thread by accident a couple of days ago--

    Thank you Mr. Moden. Another interview cut short with the simple "Name one way to get the current system time from sql server".

    This would have saved us a little time yesterday. The candidate failed all eight of the simple questions. No idea what was on the cv but these questions are only given to TSQL candidates claiming a good deal of experience.

    Having heard Jeff talk about how few people can answer this I decided to give it a try. So far 0 for 2. We are not hiring a DBA or anything that deal exclusively with sql. We are hiring for a developer. But in our shop the developers all deal with sql routinely. It is amazing to read things like "complex stored procedures and triggers". Then can't answer the simple things like how to get the current time. The best response to a question so far was this one. I asked them to briefly explain sql injection and some ways we can prevent it. After watching the person struggle for a couple minutes they started talking about how we can leverage sql injection dependency to improve performance. I somehow managed to keep a straight face as they made this up. :w00t:

    I know the struggle to keep the straight face. I've watched people trying to explain the difference between JOIN and INNER JOIN or LEFT JOIN and LEFT OUTER JOIN. And those were for SQL only positions.

    My current job is mostly SQL Development, but since I am the only SQL person I also have to do the DBA tasks. When I went on a two-week holiday last year, management wanted to have someone in to at least take over the DBA duties (mostly just monitoring, occassionally responding to an alert - and of course staying cal when a production instance goes down). My first question interview question was what I consider the most important: when you need to restore the production database, what is the first thing you should do. He did not mention tail-log backup, after nudging him in that direction he still didn't, and when I explicitly dropped that term he had no idea what I was talking about. I only asked the rest of the questions out of courtesy. I later heard that he had only Oracle background and the headhunter had "windowdressed" the resume.

    (I then decided to instruct a coworker on how to read the monitoring, how to grow databases when they insufficient free space is indicated, and not to do anything other than call my cell when anything strange happened, then verified that my hotel had a good Wifi connection. My contract is not for 100% availability even though I am the only one able to do a restore, but given the alternative I decided that I rather had an interruption of my holiday in case a restore would be needed than to have to deal with the mess that this replacement candidate would leave).


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • Sean Lange (3/24/2016)


    Alan.B (3/24/2016)


    Brandie Tarvin (3/24/2016)


    <headdesk>

    One of my coworkers just came up with the worst joke ever.

    Three DBAs walk into a NoSQL bar. Soon after, they leave - they couldn't join a table!

    Will G.

    That's similar to the old joke:

    A DBA walks in to a bar, sees a set of tables, walks up to them and asks, "may I join you?"

    Sounds like a perfect UNION to me. :hehe:

    Nah... a UNION ALL would work out better here. :w00t:

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes


    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • Ed Wagner (3/23/2016)


    Lynn Pettis (3/23/2016)


    Ed Wagner (3/23/2016)


    Lynn Pettis (3/23/2016)


    Ed Wagner (3/23/2016)


    Alan.B (3/23/2016)


    ChrisM@Work (3/23/2016)


    How many of you contractors have been so taken with a gig that you've signed up as a permie? I just did. I never expected that.

    The idea of presenting fills me with irrational fear, and yet yesterday I gave a one-hour presentation on query tuning and execution plan basics to an alarmingly large group here in the biggest meeting room we have ("we"! Did you notice that?), and it wasn't too bad. They want more, Tuning Tuesdays, every other week. I never expected that.

    I would happily attend a Chris Morris Query Tuning Tuesday but the Drive from Chicago to Berkshire is too long. Congrats on the new gig! I was a contractor for a long time but got recruited to where I am today (Slalom) which is a great company. We just opened a London Office (hint, hint - in case things don't work out πŸ˜‰ ).

    I, too, have a huge fear of presenting but have done so twice at our local SQL user groups and also for work. I like it a little more now. As an old friend once said, "You get over your fear of walking around the block by walking around the block."

    You hit the nail on the head there, Alan - You never get any better unless you try.

    BTW, if you decide to make the drive from Chicago to Berkshire, plan on stopping by Detroit on the way. πŸ˜›

    Went through Detroit on Saturday and today. Of course we never left the airport.

    Had I known that, I'd have bought you lunch, but it would have entailed you leaving the airport. πŸ˜‰ Glad you made it home safely.

    Not home yet. We got diverted to Salt Lake City and are staying in a hotel for the night.

    Well, I hope you both make it home safely tomorrow.

    Yes, we made it to DIA this morning. The entire flight cheered when the flight attendant announced our arrival. Of course this was a special flight just for those of us on the Detroit to Denver flight. There were too many to try and get us o other flights.

  • WayneS (3/24/2016)


    ChrisM@Work (3/24/2016)


    Stage fright can hit anyone I suppose.

    Yes it does... even those that speak frequently. I know of a fellow threadizen that is a very frequent speaker, yet has stage fright prior to every presentation. It really surprised me when I was told this.

    I'm surprised that you were surprised by it. I happen to know one such fellow *ahem* that seems to fit that stage fright bill very nicely. His initials are WS. πŸ˜€

    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

  • Ed Wagner (3/24/2016)


    GilaMonster (3/24/2016)


    ChrisM@Work (3/24/2016)


    Grant Fritchey (3/24/2016)


    Steve Jones - SSC Editor (3/24/2016)


    WayneS (3/24/2016)


    ChrisM@Work (3/24/2016)


    Stage fright can hit anyone I suppose.

    Yes it does... even those that speak frequently. I know of a fellow threadizen that is a very frequent speaker, yet has stage fright prior to every presentation. It really surprised me when I was told this.

    Still gets me at times.

    Last year at PASS, new session, never practiced anywhere live. Spent most of the week in my hotel rehearsing demos.

    I think that was me. I get nervous every time. I speak a lot, so that's a ton of nerves.

    I'm ... stunned. Last year at SQL Bits I sneaked into one of your talks Grant and there you were with your a$$ perched on a desk corner, cool as a dad talking to a kid, except it was a roomful and a half of bat-eared geeks eager to pick up the latest stuff and you could have heard a hair drop.

    It's called putting on an act.

    The number of times I've given a presentation and had large numbers of positive comments, while it was the last place in the world I wanted to be and it had taken a huge amount of effort to just walk into the room and I hated every minute of the talk.

    Gail, I've never seen you speak in person.

    Grant, I have seen you and if you were nervous, you hid it very well.

    I must admit that it's a bit of a relief to know that I'm not the only one who gets nervous about it. I have nowhere near the experience that you both have, but I do find it gets easier each time. I'll eventually get to the point where it doesn't come with as much anxiety, but not all at once. Like anything worth doing, it takes time.

    Something that helps to quell the nerves is to understand why you are getting nervous.

    Nervousness before speaking often is the result of personal investment. You get nervous because you want to do well. Whether you want to be there or not, you want to convey the message properly.

    Anxiety on the other hand is a different story. Anxiety is fear driven and is harder to overcome.

    Being nervous is a good thing imho.

    Being anxious requires putting on a good act to conceal 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

  • SQLRNNR (3/24/2016)


    Ed Wagner (3/24/2016)


    GilaMonster (3/24/2016)


    ChrisM@Work (3/24/2016)


    Grant Fritchey (3/24/2016)


    Steve Jones - SSC Editor (3/24/2016)


    WayneS (3/24/2016)


    ChrisM@Work (3/24/2016)


    Stage fright can hit anyone I suppose.

    Yes it does... even those that speak frequently. I know of a fellow threadizen that is a very frequent speaker, yet has stage fright prior to every presentation. It really surprised me when I was told this.

    Still gets me at times.

    Last year at PASS, new session, never practiced anywhere live. Spent most of the week in my hotel rehearsing demos.

    I think that was me. I get nervous every time. I speak a lot, so that's a ton of nerves.

    I'm ... stunned. Last year at SQL Bits I sneaked into one of your talks Grant and there you were with your a$$ perched on a desk corner, cool as a dad talking to a kid, except it was a roomful and a half of bat-eared geeks eager to pick up the latest stuff and you could have heard a hair drop.

    It's called putting on an act.

    The number of times I've given a presentation and had large numbers of positive comments, while it was the last place in the world I wanted to be and it had taken a huge amount of effort to just walk into the room and I hated every minute of the talk.

    Gail, I've never seen you speak in person.

    Grant, I have seen you and if you were nervous, you hid it very well.

    I must admit that it's a bit of a relief to know that I'm not the only one who gets nervous about it. I have nowhere near the experience that you both have, but I do find it gets easier each time. I'll eventually get to the point where it doesn't come with as much anxiety, but not all at once. Like anything worth doing, it takes time.

    Something that helps to quell the nerves is to understand why you are getting nervous.

    Nervousness before speaking often is the result of personal investment. You get nervous because you want to do well. Whether you want to be there or not, you want to convey the message properly.

    Anxiety on the other hand is a different story. Anxiety is fear driven and is harder to overcome.

    Being nervous is a good thing imho.

    Being anxious requires putting on a good act to conceal it.

    Thanks, Jason. I know I'm nervous because I invest a great deal of time into a presentation and I want to present it well. If being nervous is a good thing, I must have been great when I started. πŸ˜› In all seriousness, it has gotten better as I've done it.

  • SQLRNNR (3/24/2016)


    Anxiety on the other hand is a different story. Anxiety is fear driven and is harder to overcome.

    I can vouch for that.

    Being anxious requires putting on a good act to conceal it.

    And that.

    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
  • To those who celebrate: Happy Good Friday.

    Of course, you won't see this until next week probably (given how many people are off), but still. @=)

    EDIT: I suppose I should put in a Happy Easter as well. I celebrate the bunny, and the chocolate... Because one must always celebrate the chocolate regardless of the holiday.

    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.

  • Brandie Tarvin (3/25/2016)


    To those who celebrate: Happy Good Friday.

    Of course, you won't see this until next week probably (given how many people are off), but still. @=)

    EDIT: I suppose I should put in a Happy Easter as well. I celebrate the bunny, and the chocolate... Because one must always celebrate the chocolate regardless of the holiday.

    Thank you. May you also have a good weekend. May you all have time to pause and enjoy your families.

    Personally, I celebrate the reason for Easter. Given this is a mixed group, I will refrain from further definition.

Viewing 15 posts - 53,236 through 53,250 (of 66,712 total)

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