Forum Replies Created

Viewing 15 posts - 16 through 30 (of 176 total)

  • RE: Upgrade From SQL 2012 to SQL 2016 - Problem with Certificates

    I use certs extensively, so this is definitely good information to know.


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

    July 23, 2018 at 7:31 am

    #1998588

  • RE: An Unlikely Taste for Documentation and Archiving

    I’ve only got a finite supply of enthusiasm for communicating with myself.

    I love this quote.

    I recently realized my lack of documentation is detrimental as I considered moving...


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

    May 31, 2018 at 7:58 am

    #1992471

  • RE: Subset the frame

    But what if we wanted to return all players who hadn't used steriods? ðŸ˜‰


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

    May 30, 2018 at 7:28 am

    #1992299

  • RE: Does the Tone matter?

    I'm planning on leaving my current position, mostly because I don't care for my current manager's attitude.  He has an air of superiority and it is quite apparent in the...


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

    May 15, 2018 at 7:43 am

    #1990519

  • RE: Setting Column Names

    It feels like there are too many different ways to do the same thing in R.  This Stack Overflow question deals with this concept and the way Steve...


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

    April 4, 2018 at 9:15 am

    #1985481

  • RE: ETL or ELT

    This is a really interesting discussion.  I do all my work via ELT - load the data from files into SQL Server staging tables, then transform as it is loaded...


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

    April 3, 2018 at 7:54 am

    #1985285

  • RE: Symmetric Except

    Fun question, thanks!


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

    March 29, 2018 at 7:32 am

    #1984942

  • RE: Performance of GROUP BY multiple columns

    I like this question, thanks for submitting it.


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

    March 27, 2018 at 7:21 am

    #1984648

  • RE: The DTU Counters

    Carlo Romagnano - Thursday, March 22, 2018 2:32 AM

    Here states different:

    DTUs provide a way to describe the relative capacity of...


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

    March 22, 2018 at 7:47 am

    #1984275

  • RE: Side by Side Support

    Interesting, I found this documentation which seems to contradict the documentation you posted:

    Any scenarios not specified in the list above are not supported, including but not...


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

    March 19, 2018 at 7:26 am

    #1983751

  • RE: FCI Diagnostics Log

    Hmm, on the Failover Policy for Failover Cluster Instances documentation, I see the following:

    During SQL Server startup, the WSFC service uses the SQL Server Database Engine...


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

    March 12, 2018 at 9:22 am

    #1982776

  • RE: Index Fill Factor

    George Vobr - Tuesday, February 6, 2018 8:19 AM

    Thanks for the interesting question Mohammed. Quite hard, but the documentation helped me.
    Is it...


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

    February 6, 2018 at 8:31 am

    #1978715

  • RE: Index Fill Factor

    I would like to see documentation on this: 

    When a new transaction requires a new page, SQL Server doesn't apply the 80% fill factor for new pages allocated.

    I have...


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

    February 6, 2018 at 7:33 am

    #1978704

  • RE: Critical SQL Server Patches for Meltdown and Spectre

    Why isn't this SQL Server KB showing up in Windows Update?  I feel like these have showed up there in the past, though since we're on 2008 R2 it's been...


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

    January 18, 2018 at 7:53 am

    #1976329

  • RE: What are the contents?

    Kaye Cahs - Friday, December 15, 2017 7:07 AM

    Why is there no ContactID 4?
    Isn't that where "Brett" should go?

    My favorite Vikings Quarterback...


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

    December 15, 2017 at 8:04 am

    #1972302

Viewing 15 posts - 16 through 30 (of 176 total)