Forum Replies Created

Viewing 15 posts - 16,066 through 16,080 (of 39,970 total)

  • RE: Value of backing up trans log dumps to tape...?

    Ultimately you do have to make some decisions on what to keep. Can your systems go back 2 weeks and still work? Or course, but if you go back that...

  • RE: Enabling TDE

    Glad you enjoyed it. This is one of those tricky subjects.

  • RE: Query Help

    Is this what you mean? Note that it doesn't cascade the values forward.

    CREATE TABLE Foobar

    ( a1 datetime

    , a2 datetime

    , a3 datetime

    , a4 datetime

    , a5 datetime

    )

    GO

    INSERT foobar (a1) SELECT '1/1/2011'

    INSERT...

  • RE: Value of backing up trans log dumps to tape...?

    I recommend keeping 2 fulls and the logs since around. After that, I've never seen the need to recover a database in the past to a point in time, so...

  • RE: Are the posted questions getting worse?

    Jeff Moden (5/28/2011)


    Steve Jones - SSC Editor (5/27/2011)


    Now we got the $27k Prius in '07, but got a $1500 tax credit and saved a ton of gas.

    What did it do...

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (5/27/2011)


    I've been meaning to ask, how are your horses doing? I hear there's a quarantine in Colorado right now.

    We're fine. Horses have been on property for weeks, so...

  • RE: Are the posted questions getting worse?

    bitbucket-25253 (5/27/2011)


    Steve did you drive that '92 240D in Virginia when you lived and worked there. If so, you might have seen another same model, year '80 with a...

  • RE: Are the posted questions getting worse?

    Jack Corbett (5/27/2011)


    GilaMonster (5/27/2011)


    Precon and spotlight! Could this PASS Summit get any better?

    Sure, I could go, and attend the precon and the spotlight!

    Side note for those not on Twitter, I...

  • RE: Are the posted questions getting worse?

    bitbucket-25253 (5/27/2011)


    Driving a Mercedes 300 1992 (Diesel with super charger) now at 303,562 miles. Change oil every 5,000 ... maintence every 10,000 costs $90.00, and runs like a charm...

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (5/27/2011)


    GSquared (5/27/2011)


    A friend of mine says that what a friend of his does is buy old clunker cars, usually for around $2,000 or so. Then the only...

  • RE: The Backup Passwords

    The passwords in native SQL Server backups are weak.

    I was thinking more of managing the encryption keys/passwords for third party tools that encrypt the backups. Tools like SQL Backup...

  • RE: The Backup Passwords

    mgraham 67977 (5/27/2011)


    We have implemented something we call a poker key server. To retrieve a database encryption key you have to enter a long (20 character) password of which ten...

  • RE: Page compression

    Arrgggghhhhh.

    My apologies. The second sentence was intended to be an example, not part of the questions and I inadvertently phrased it backwards.

    I've awarded back points to everyone so far and...

  • RE: Hints Are Not Always Better

    Congrats!

  • RE: grant access to Service account sid(security identifier) in SQL 2008

    you don't add the service name. You add the account under which the service runs. Those are separate things.

    The service name is just meta data, like the full name for...

Viewing 15 posts - 16,066 through 16,080 (of 39,970 total)