Forum Replies Created

Viewing 15 posts - 1 through 15 (of 176 total)

  • Reply To: The Great Developer Resignation

    I just switched jobs a couple months ago.  I went from one of the big fortune 500 companies to a smaller manufacturer.  The move was 100% about culture.  I really...


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]
    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

    February 4, 2022 at 1:50 pm

    #3980714

  • RE: Speedy Table Variables

    Ran my test in 2008 R2:


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]
    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

    March 28, 2019 at 6:46 am

    #2034084

  • RE: MOT identity

    Are you sure that's right?  In the page the answer links to, I see this:

    As others have pointed out, this documentation also contradicts your answer:
    https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/implementing-identity-in-a-memory-optimized-table?view=sql-server-2017

    Thank you


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]
    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

    February 26, 2019 at 6:41 am

    #2022960

  • RE: A Supercomputer in My Pocket

    greg.lovekamp - Friday, February 15, 2019 9:42 AM

    The phrase "a real book" disturbs me: what defines "real"? Does it have to...


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]
    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

    February 20, 2019 at 9:52 am

    #2022492

  • RE: A Supercomputer in My Pocket

    With great power comes great responsibility.  While having a computer in our pockets is ultra-convenient, it's also quite addictive, to the point that many people use it to escape reality. ...


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]
    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

    February 15, 2019 at 7:20 am

    #2022147

  • RE: The Giving Back Workload

    Coming from SQL Server, I got very frustrated by the Oracle community when trying to start administering one of those databases.  I couldn't understand why their community was so much...


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]
    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

    January 4, 2019 at 6:59 am

    #2017970

  • RE: Small negative numbers

    radek.celuch - Tuesday, November 27, 2018 12:19 AM

    How about storing them as positives as tinyint but interpret as negatives with computed columns,...


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]
    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

    November 27, 2018 at 6:30 am

    #2014637

  • RE: The funny WHERE

    Jonathan AC Roberts - Sunday, November 25, 2018 8:02 AM

    Should say: I get all rows for all statuses where  oh.OrderTotal > 0

    Yep, this...


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]
    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

    November 26, 2018 at 6:33 am

    #2014498

  • RE: Skills for Everyone in Tech

    I got my undergrad in math and have found about half of it very helpful in my professional career.  Discrete math is particularly helpful when working in SQL.  I am...


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]
    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

    October 30, 2018 at 7:52 am

    #2011682

  • RE: COLUMNPROPERTY in SQL Server 2016/2017

    I find it interesting that Microsoft docs say Column Sets start with SQL Server 2016, yet the ColumnProperty function works for IsColumnSet even back in SQL 2008 R2.


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]
    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

    October 11, 2018 at 6:58 am

    #2009075

  • RE: QUOTENAME() Types

    Toreador - Thursday, October 4, 2018 4:28 AM

    I don't think that's the right answer. It always returns nvarchar - but if the...


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]
    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

    October 4, 2018 at 6:51 am

    #2008030

  • RE: College Degrees Shouldn't Be Required for Tech Jobs

    The other thing I'd like to point out, having graduated from college just 10 short year ago, is that, at least here in the US, our university system is quite...


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]
    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

    September 7, 2018 at 8:57 am

    #2004891

  • RE: College Degrees Shouldn't Be Required for Tech Jobs

    I just finished a job search (next week is my last at my current employer before moving on to the next one) and I can attest that most of the...


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]
    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

    September 7, 2018 at 7:55 am

    #2004870

  • RE: The UPDATE() function

    That was tricky because my brain is trained to think of 1 as true and 0 as false.  I read the last to answers as the same before I had...


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]
    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

    August 10, 2018 at 7:45 am

    #2001229

  • RE: When someone asks you what you do for work, how do you answer?

    I tell people I'm a professional fisherman who works on computers while I'm waiting for my first big catch.
    It seems that most people know or care little the different...


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]
    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

    July 30, 2018 at 7:30 am

    #1999463

Viewing 15 posts - 1 through 15 (of 176 total)