Forum Replies Created

Viewing 8 posts - 1 through 8 (of 8 total)

  • RE: Virtualization skill and SQL Server

    sturner (11/18/2011)

    I concur with perry that the pros and cons and pitfalls of virtualization need to be embraced by any well rounded DBA.

    That makes three of us! However, in...

    November 18, 2011 at 12:49 pm

    #1410159

  • RE: difference between unquie and PK constraint

    Thanks GilaMonster.

    I'd like you to confirm the below two highlights which I believe are what you are saying:

    1) Unique constraint allows ONE NULL value per column where Unique constraint...

    November 18, 2011 at 4:09 am

    #1409789

  • RE: Does the full backup clear/truncate the t-log?

    The log doesn't autoshrink to free the space back to the OS.

    The vlf are marked as resusable.

    Oh, got you. Which is what I realized. True, the log file...

    November 14, 2011 at 9:38 am

    #1407330

  • RE: Does the full backup clear/truncate the t-log?

    p.s. Nothing deletes inactive log records from the log. Ever.

    Hmmm, then how are the spaces freed up in the log file? Or maybe you mean that inactive logs entries...

    November 14, 2011 at 9:32 am

    #1407316

  • RE: DB mirroring and Log backup chain

    GilaMonster (11/14/2011)

    There's no 'log chain' on a mirroring partner. Mirroring doesn't depend on log backups to copy transactions across (as log shipping does). You can't take log backups on a...

    November 14, 2011 at 8:10 am

    #1407186

  • RE: Trancender too simple?

    Did Transcender honor their 100% money back guarantee by chance?

    November 13, 2011 at 2:01 pm

    #1406866

  • RE: If you passed exam 70-450

    GilaMonster (11/13/2011)

    JakeSA (11/13/2011)

    but not really so in Development unless you are a hard-core programmer (which you cannot teach yourself to be because good programmer is more in your genes rather...

    November 13, 2011 at 1:54 pm

    #1406863

  • RE: If you passed exam 70-450

    True, but you need some education to get there so I know we're kind of talking about catch 22, but which one next? Development or BI after admin?

    November 13, 2011 at 8:22 am

    #1406837

Viewing 8 posts - 1 through 8 (of 8 total)