Forum Replies Created

Viewing 15 posts - 361 through 375 (of 3,221 total)

  • RE: What is Normal?

    Jeff Moden (11/22/2016)


    ...There's nothing that says a table can't have more than one unique index on it.

    I am always amazed at how many people struggle to believe this.

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • RE: What is Normal?

    Charles Kincaid (11/22/2016)


    ...Gary I agree with you almost all of the time. I prefer to not be harsh in criticizing folks. Here in the U.S. we have been...

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • RE: how add contents of the string to 2 table objects

    Gary Varga (11/22/2016)


    Thanks for posting your final solution.

    (Mine worked for me but maybe copy 'n' paste lost the newline character).

    Looking at the original post I don't know how mine ever...

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • RE: how add contents of the string to 2 table objects

    Thanks for posting your final solution.

    (Mine worked for me but maybe copy 'n' paste lost the newline character).

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • RE: how add contents of the string to 2 table objects

    I would get the individual values as such:

    $v = $string.Split(",");

    This splits the values as follows:

    AvgSQLCpu

    AVGCpu

    AVGOtherCpu

    100

    97

    2

    alertType

    alertStatus

    alertGenerate

    alertDetails

    HIGHCPU

    ERROR

    0

    Where $v[0] is the string "AvgSQLCpu", $v[1] is the string "AVGCpu", $v[2] is the string "AVGOtherCpu"...

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • RE: Monitor All the Changes

    It seems that generally we need to consider warnings to be important enough to warn the user immediately, specific performance measurement important enough to be monitored or events important enough...

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • RE: What is Normal?

    RonKyle (11/21/2016)


    I think there is a very specific distinction between data which is unnormalized vs denormalized

    I agree with you, and maybe you, I, and some others can make that distinction....

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • RE: Free eBook from PacktPub: Microsoft SQL Server 2012 Performance Tuning Cookbook - TODAY ONLY!!!

    Absolutely. I have only missed two that I wanted and one of those I got when it was offered again on a different day.

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • RE: Wow. Just Wow

    As usual it appears to be human execution and choices rather than technology that caused the issues...trouble is that technology is an enabler (often of dreadful things).

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • RE: What is Normal?

    It always amazes me the number of experienced professionals who do not consider the longevity of software and databases. Some must work on too many greenfield projects and never support...

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • RE: SQL Server 2016 is Just Faster

    Markus (11/17/2016)


    Microsoft releases new things for SQL Server to Azure first. Then it will become GA to on site installs after that.

    Exactly that.

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • RE: Share the Interesting Work

    All team members should do both types over time. Don't split up tasks too small but do break down what you can. Also, automate as much as possible.

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • RE: SQL Server 2016 is Just Faster

    It does appear that the Azure first policy is certainly bearing the fruits of their labours.

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • RE: A Joke Come True

    As a developer, I only care about two aspects (leaving all else to DBAs):

    • Does my connection string/integrated authentication work?
    • Does SSMS (or alternative) work?

    I hope that this is something that pleases...

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • RE: A Joke Come True

    I have known three SQL Server and Windows using companies that seriously considered how they could leverage Linux; one stayed as they were, one moved everything except one SQL Server/Windows...

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

Viewing 15 posts - 361 through 375 (of 3,221 total)