Are the posted questions getting worse?

  • jasona.work

    SSC-Forever

    Points: 49889

    Well this evening was a capper on the last couple weeks, and in both a bad and a good way...

    Bad in that it took me over an hour to get home, rather than my usual 30-40 minutes, because of some seriously backed up traffic.

    Good in that, just before the end of the day, I get an e-mail about an update to my electronic personnel file...

    I peek in to see what changed, because that I'm aware of there was nothing going on that should've resulted in anything getting added / changed.

    I'm presuming because our audit went as well as it did, that that's the reason for the bonus coming my way...

    It'll be interesting to find out if anyone else on the team got one too...

  • Ray K

    SSC-Dedicated

    Points: 31071

    Steve Jones - SSC Editor wrote:

    jasona.work wrote:

    And yet another week of dealing with the "anti-virus" virus...

    ...

    So how was your day?

    Good and bad. worked a bit and then spent the last day and evening with my daughter. Today she moves into university.

    IMG_20190815_135736_01

    Congrats, Steve!  How'd you like Potsdam?

    I have a lot of friends who went to Potsdam.

    Just as long as she doesn't root for Clarkson hockey...! 😀

    +--------------------------------------------------------------------------------------+
    Check out my blog at https://pianorayk.wordpress.com/

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715912

    Ray K wrote:

    Congrats, Steve!  How'd you like Potsdam?

    I have a lot of friends who went to Potsdam.

    Just as long as she doesn't root for Clarkson hockey...! 😀

    It's a neat town. We were up there for 4 days, and I enjoyed it. Not close to anything, but I think it will be a good spot for her.

  • Luis Cazares

    SSC Guru

    Points: 183569

    Steve Jones - SSC Editor wrote:

    Luis Cazares wrote:

    It's been good. We're still waiting for our baby girl to decide to be born. She's taking her time. (Yesterday was the "due date")

    I'm assuming by now congratulations are in order. Enjoy the new little one.

    You were really close. Our little Renata was born on August 19 at 2:12pm EST. There were some complications and she's spending some time at NICU, but getting healthier and stronger every day. We hope to have her home soon, but don't expect her before next week.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • Beatrix Kiddo

    SSC-Dedicated

    Points: 32377

    Congratulations. I hope everybody is doing ok. That sounds very hard.

  • David Burrows

    SSC Guru

    Points: 64521

    Luis Cazares wrote:

    Steve Jones - SSC Editor wrote:

    Luis Cazares wrote:

    It's been good. We're still waiting for our baby girl to decide to be born. She's taking her time. (Yesterday was the "due date")

    I'm assuming by now congratulations are in order. Enjoy the new little one.

    You were really close. Our little Renata was born on August 19 at 2:12pm EST. There were some complications and she's spending some time at NICU, but getting healthier and stronger every day. We hope to have her home soon, but don't expect her before next week.

    Congratulations 🙂

    Far away is close at hand in the images of elsewhere.
    Anon.

  • Thom A

    SSC Guru

    Points: 98333

    Luis Cazares wrote:

    You were really close. Our little Renata was born on August 19 at 2:12pm EST. There were some complications and she's spending some time at NICU, but getting healthier and stronger every day. We hope to have her home soon, but don't expect her before next week.

    Congratulations and I hope you get her home soon. 🙂

    Thom~

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

  • Grant Fritchey

    SSC Guru

    Points: 395510

    Luis Cazares wrote:

    Steve Jones - SSC Editor wrote:

    Luis Cazares wrote:

    It's been good. We're still waiting for our baby girl to decide to be born. She's taking her time. (Yesterday was the "due date")

    I'm assuming by now congratulations are in order. Enjoy the new little one.

    You were really close. Our little Renata was born on August 19 at 2:12pm EST. There were some complications and she's spending some time at NICU, but getting healthier and stronger every day. We hope to have her home soon, but don't expect her before next week.

    That's wonderful news. Congratulations.

     

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Brandie Tarvin

    SSC Guru

    Points: 172536

    Luis Cazares wrote:

    You were really close. Our little Renata was born on August 19 at 2:12pm EST. There were some complications and she's spending some time at NICU, but getting healthier and stronger every day. We hope to have her home soon, but don't expect her before next week.

    Congratulations on your little girl. I feel your NICU pain. My little boy spent 6 weeks there learning how to eat and breath. We got lucky. He was the healthiest baby in the NICU at the time. Lots of other babies had worse problems. I wish you the best in her coming out soon without any issues.

    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.

  • Beatrix Kiddo

    SSC-Dedicated

    Points: 32377

    I'm interviewing a lot of candidates for a mid-level Production DBA role at the moment, and one of the questions I ask is what's the difference between truncating a transaction log and shrinking a transaction log. Nobody has answered it correctly yet, even the ones who are otherwise quite strong candidates. Some of the candidates even get the two things exactly the wrong way round. Most of them think it's something you should NEVER do. (I guess they never take t-log backups in their estate, then?)

    Baffling. I started to doubt myself after a few of those interviews, and I even Googled it to check that I hadn't misunderstood it myself all these years.

  • Brandie Tarvin

    SSC Guru

    Points: 172536

    Beatrix Kiddo wrote:

    I'm interviewing a lot of candidates for a mid-level Production DBA role at the moment, and one of the questions I ask is what's the difference between truncating a transaction log and shrinking a transaction log. Nobody has answered it correctly yet, even the ones who are otherwise quite strong candidates. Some of the candidates even get the two things exactly the wrong way round. Most of them think it's something you should NEVER do. (I guess they never take t-log backups in their estate, then?)

    Baffling. I started to doubt myself after a few of those interviews, and I even Googled it to check that I hadn't misunderstood it myself all these years.

    Welllll. I thought (even though people do do it) that shrinking a transaction log was something you were never supposed to do. Soooo I would definitely have answered that to the shrinking part of the question.

    EDIT: Does that mean I don't get the job? @=)

    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.

  • Grant Fritchey

    SSC Guru

    Points: 395510

    Beatrix Kiddo wrote:

    I'm interviewing a lot of candidates for a mid-level Production DBA role at the moment, and one of the questions I ask is what's the difference between truncating a transaction log and shrinking a transaction log. Nobody has answered it correctly yet, even the ones who are otherwise quite strong candidates. Some of the candidates even get the two things exactly the wrong way round. Most of them think it's something you should NEVER do. (I guess they never take t-log backups in their estate, then?)

    Baffling. I started to doubt myself after a few of those interviews, and I even Googled it to check that I hadn't misunderstood it myself all these years.

    Ask them the difference between blocking and deadlocks. Those are always awesome answers. Less fun, but still fun, what's the difference between a clustered and non-clustered index is a great question.

    I'm not even remotely surprised that you're getting bad answers. The level of knowledge out there of "mid-level", and sometimes even "senior", people is appalling. One year of experience, multiplied. That's most people, sadly.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Chris Harshman

    SSC-Forever

    Points: 41765

    Congrats Luis!  hope the family is doing well 🙂

  • BrainDonor

    SSCoach

    Points: 19202

    Grant Fritchey wrote:

    Ask them the difference between blocking and deadlocks. Those are always awesome answers. Less fun, but still fun, what's the difference between a clustered and non-clustered index is a great question.

    I'm not even remotely surprised that you're getting bad answers. The level of knowledge out there of "mid-level", and sometimes even "senior", people is appalling. One year of experience, multiplied. That's most people, sadly.

    Interviewing a Senior DBA, I was told that a full backup didn't back up the log file. That would make a restore interesting.

    Steve Hall
    Linkedin
    Blog Site

  • Sean Lange

    SSC Guru

    Points: 286446

    Grant Fritchey wrote:

    Beatrix Kiddo wrote:

    I'm interviewing a lot of candidates for a mid-level Production DBA role at the moment, and one of the questions I ask is what's the difference between truncating a transaction log and shrinking a transaction log. Nobody has answered it correctly yet, even the ones who are otherwise quite strong candidates. Some of the candidates even get the two things exactly the wrong way round. Most of them think it's something you should NEVER do. (I guess they never take t-log backups in their estate, then?)

    Baffling. I started to doubt myself after a few of those interviews, and I even Googled it to check that I hadn't misunderstood it myself all these years.

    Ask them the difference between blocking and deadlocks. Those are always awesome answers. Less fun, but still fun, what's the difference between a clustered and non-clustered index is a great question.

    I'm not even remotely surprised that you're getting bad answers. The level of knowledge out there of "mid-level", and sometimes even "senior", people is appalling. One year of experience, multiplied. That's most people, sadly.

    And don't forget "old faithful", how do you get the current system time using t-sql. Another one I have found interesting is something along the lines of "can you explain sql injection and how we can exploit it to our advantage". Talk about some interesting answers.

    _______________________________________________________________

    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/

Viewing 15 posts - 63,931 through 63,945 (of 64,085 total)

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