Forum Replies Created

Viewing 15 posts - 481 through 495 (of 631 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (6/19/2013)


    Please tell me I'm reading that last post from the OP wrong.

    http://www.sqlservercentral.com/Forums/Topic1464172-391-1.aspx

    It would appear that the answer to your last question is not so much "Yes" as "YES! ...

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

  • RE: Fizz Buzz interview questions for phone screens?

    Dird (6/6/2013)


    Jeff Moden (6/6/2013)


    Out of the last 20 developers I've interviewd, NONE of them has used a setbased method or a Tally Table. I can train people to be...

    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 (6/4/2013)


    My Recovery Plan

    1) SCREAM really loudly so everyone knows there is a problem.

    2) Run out of the building as fast as possible.

    3) Update my resume.

    4) Job hunt.

    5) Repeat...

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

  • RE: Are the posted questions getting worse?

    rodjkidd (6/4/2013)


    Just got off a conference call, and the subject of DR came up.

    The reply?

    "well it would be nice, but we've never had any problems so far"...

    I'm sure we've all...

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

  • RE: Moving from SQL 2012 Enterprise to Standard - possible?

    Loundy (5/23/2013)


    unfortunately downgrade isn't possible.

    you could install standard next to enterprise and copy the dbs to it before uninstalling to minimize any downtime, but as mentioned, back your dbs up...

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

  • RE: Function To Add [n] Days to A Date and Adjust to the Nearest Business Date

    david.holley (4/24/2013)


    Woah! My brain just exploded (a la Mars Attacks!). That'll take some time to digest. It didn't occur to me until just now that most major US holidays observed...

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

  • RE: Language British

    Regional settings on her machine?

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

  • RE: Zettabytes and Beyond

    To paraphrase ...

    Data is big. Really big. You just won't believe how vastly hugely mind-bogglingly big it is.

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

  • RE: The Gambler

    henrik staun poulsen (3/14/2013)


    Hi Steve,

    We also almost never run CHECKDB.

    This is because it takes tooooooo long.

    I'm taking something above 50 hours.

    When we restore a backup onto our test system, the...

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

  • RE: Fragmentation

    No log backup means

    "My data is of no value to the business, it doesn't matter if I lose all changes since the last full backup". If this is...

    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 (2/13/2013)


    Personally I find LMGTFY to be incredibly condescending, I'd feel quite insulted if someone gave me that kind of reply. I'll do the search for people if I don't...

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

  • RE: Page Life Expectancy Extremely high

    PiMané (2/7/2013)


    Is there a way of "forcing" PLE to a max value, just like sql server max memory?!

    Thks,

    Pedro

    Why would you ever want to force pages out of cache in order...

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

  • RE: Employer asking for Social Media login?

    Indianrock (1/18/2013)


    Maybe the larger question is why an employer would have the gall to request this.

    As a screening question? If you have someone wanting to work with SQL Server,...

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

  • RE: Transactional log is full.. space recovery lead to BLocking

    anthony.green (1/30/2013)


    andrew gothard (1/30/2013)


    s it's a DEV box, try running this then retrying

    DECLARE @DBName NVARCHAR(200);

    SET @DBName = '<Enter your db name here>';

    DECLARE @spid INT;

    DECLARE IHateCursors CURSOR FOR

    SELECT

    spid

    FROM

    master.dbo.sysprocesses...

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

  • RE: Transactional log is full.. space recovery lead to BLocking

    s it's a DEV box, try running this then retrying

    DECLARE @DBName NVARCHAR(200);

    SET @DBName = '<Enter your db name here>';

    DECLARE @spid INT;

    DECLARE IHateCursors CURSOR FOR

    SELECT

    spid

    FROM

    master.dbo.sysprocesses

    WHERE

    dbid =...

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

Viewing 15 posts - 481 through 495 (of 631 total)