Forum Replies Created

Viewing 15 posts - 271 through 285 (of 631 total)

  • RE: Drop and Recreate

    chrisn-585491 (12/15/2014)


    Maybe SSMS needs to be rebuilt to fully support source control and versioning?

    Good god yes. Working with TFS and SSMS is just hideous beyond belief

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (12/17/2014)


    Brandie Tarvin (12/16/2014)


    WHOO! #HappySnoopyDance

    I just spent 2 & 1/2 days reworking a package and its supporting tables / stored procedures. Previous time of execution between 8 - 12...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: xp_cmdshell vs. stored proc

    Phil's point still stands.

    There's a production freeze, you ignored it, if / when this comes out you're right in the firing line for ignoring it. In most places I've...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Track what's running when autogrow occurs

    Got it.

    Thought I'd post how I sorted this in case a search engine brings anyone else wanting to do the same here. After first tryring using Service Broker and...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: SQL DBA knowing user passwords

    lshanahan (11/26/2014)


    Markus (11/25/2014)


    You guys must live in a perfect world of applications... However, the bulk of the SQL Server based apps are small companies and don't have the resources or...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Are the posted questions getting worse?

    spaghettidba (12/10/2014)


    SQLRNNR (12/10/2014)


    andrew gothard (12/10/2014)


    Aye - I've got one of those too. Even better - unless I've completely misread the trace, someone - somewhere read that "SQL Server works...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Are the posted questions getting worse?

    Jack Corbett (12/9/2014)


    Steve Jones - SSC Editor (12/9/2014)


    andrew gothard (12/9/2014)


    App set up so exactly the same call is made a shedload of times? I've actually seen a...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (12/9/2014)


    andrew gothard (12/9/2014)


    App set up so exactly the same call is made a shedload of times? I've actually seen a 'database problem' where things...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Are the posted questions getting worse?

    GilaMonster (12/9/2014)


    Jack Corbett (12/5/2014)


    GilaMonster (12/5/2014)


    And crisis, panic, run around screaming, the EF-based app is slow.

    600MB database, generating 5GB of trace data in 1 hour....

    Ouch, I don't even...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Are the posted questions getting worse?

    Stuart Davies (12/2/2014)


    GilaMonster (12/2/2014)


    For @#$^%&%$

    "The server's got 8 cores and 28GB of memory. It doesn't matter if it's scanning a 200 000 row table. It's not going to be a...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: SQL Best practices, policies and code-smells.

    Jeff Moden (2/1/2014)


    I could rant for a couple of hours on the term "Best Practices" but I won't put anyone through that. Suffice it to say that I've become...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Are the posted questions getting worse?

    David Burrows (11/21/2014)


    Well Jeff would have to employ GBAG (Glass By Agonizing Glass) or get an Overflow Exception 😀

    Agreeable, surely?

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Are the posted questions getting worse?

    Bar in my home town.

    Can't see it being suitable for a gathering, somehow. Certainly if Jeff Moden's invited,

    http://www.tavistockleisure.com/r-bar.htm

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Backing up a production SQL Database

    Just one question, you are aware that Diff backups aren't incremental? Ie, your last differential backup will back up every page changed since your last *full* backup, not your...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Adding SQL Server 2014 node to SQL Server 2008 R2 cluster

    You're very welcome, glad you found it useful, and thank you for the feedback

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

Viewing 15 posts - 271 through 285 (of 631 total)