Forum Replies Created

Viewing 15 posts - 31 through 45 (of 176 total)

  • RE: Holiday parties: Do you love them or hate them?

    I am one of those introverts, but I also work with some people I really enjoy being around.  I prefer to go to the Christmas party, eat the free dinner,...


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]

    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

  • RE: Compressing tables

    The error I get indicates 18 bytes of internal overhead:

    Msg 1701, Level 16, State 1, Line 6
    Creating or altering table 'CompressionTest' failed because the minimum row...


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]

    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

  • RE: How Large is a Table?

    I would like to see a reference in the answer as well.  I found two different Microsoft documentation pages and neither one mentioned a 7 byte overhead.


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]

    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

  • RE: Does Your Work Attire Really Make a Difference?

    I don't know whether dressing formal helps you work better or more professionally.  I have worked in both formal and casual environments, and I much prefer casual.  The place I...


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]

    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

  • RE: Physical or Virtual Storage

    I think this mostly depends on the size of the organization.  If your IT department is 5 people like mine, you probably don't have a SAN admin and you need...


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]

    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

  • RE: Python Lists

    "By definition, the first two numbers in the Fibonacci sequence are either 1 and 1, or 0 and 1, depending on the chosen starting point of the sequence, and each...


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]

    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

  • RE: Compressing Integers

    I don't get this: 

    One trillion integers won't fit in an INT column so a BIGINT type is needed.

    Can someone explain?


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]

    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

  • RE: The Order of Processing

    I'm curious about ON.  Is that referring to the columns used in the JOIN?  If so, why would that be before the JOIN?


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]

    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

  • RE: Power BI - Rename Table Column headings

    LOL, with the Power BI update that just came out, the timing on this article is funny.

    Regardless, thanks for sharing Daniel Taylor.  It's great to see more Power...


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]

    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

  • RE: Backup Encryption Options

    Does anyone else dislike the new docs.microsoft.com documentation pages?  I find them so much harder to read than the msdn pages.


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]

    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

  • RE: Dealing with Supervision

    Eric M Russell - Thursday, April 6, 2017 7:35 AM

    Perhaps the best way to tactfully brush someone off when they are peering...


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]

    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

  • RE: What do you do to relax after work?

    Prayer is a great way to recharge after a stressful day.  Like St Augustine said, "You have made us for yourself, O Lord, and our hearts are restless until they...


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]

    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

  • RE: It Just Runs Faster - In-Memory Optimized Operations

    Hmm, I was looking at the documentation here: https://msdn.microsoft.com/en-us/library/mt694156.aspx, which under the "How In-Memory OLTP features work so much faster" section has a subsection...


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]

    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

  • RE: Multiple TCP Ports

    I like that question a lot, keep them coming Marek!


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]

    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

  • RE: Trace Flag Status

    Will DBCC TRACESTATUS really show other users' session-based trace flag?  The documentation reads to me that you will only see global or your session's trace flags.


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]

    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

Viewing 15 posts - 31 through 45 (of 176 total)