Forum Replies Created

Viewing 15 posts - 3,151 through 3,165 (of 9,725 total)

  • RE: System Tables for Database Mirroring

    Nevermind. Finally found a link with them listed.

    sys.database_mirroring

    sys.database_mirroring_endpoints

    sys.database_mirroring_witnesses

    sys.dm_db_mirroring_connections

    Thanks anyway.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Backup SQL settings?

    dstoltz 35443 (8/18/2014)


    Thanks everyone - unfortunately, we don't have a DR site, or even a DR server...we have a 4 hour response time support to get the server fixed if...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Sleeping Log Reader Agent blocking Distribution clean up job

    First, let's try approaching this problem as if it has nothing to do with the VLFs issue, okay?

    What is the schedule (if any) of your snapshot agent?

    How big are your...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Compare two columns

    So did Tom answer your question, then?

    If so, please mark his post as the solution. If not, please post again and tell us why it didn't work for you.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: SQL DBA high ended question (5+ years’ experience)

    Jeff Moden (8/16/2014)


    Evil Kraig F (8/15/2014)


    Brandie Tarvin (8/15/2014)


    It's Wednesday. 3 people walk up to your cube. One is from the QA team, one is from the reporting team, and one...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: SQL DBA high ended question (5+ years’ experience)

    GilaMonster (8/15/2014)


    Evil Kraig F (8/15/2014)


    Is it bad that my first question is to the reporting team guy: "Which reports, and what's their SLA's?" while asking the QA person to email...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: SQL DBA high ended question (5+ years’ experience)

    Evil Kraig F (8/15/2014)


    Brandie Tarvin (8/15/2014)


    It's Wednesday. 3 people walk up to your cube. One is from the QA team, one is from the reporting team, and one is a...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: SQL DBA high ended question (5+ years’ experience)

    I'm thinking about the original post and I think I'd ask questions like this:

    It's Wednesday. 3 people walk up to your cube. One is from the QA team, one is...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: SQL DBA high ended question (5+ years’ experience)

    GilaMonster (8/11/2014)


    paul.knibbs (8/11/2014)


    Jeff Moden (8/9/2014)

    With the understanding you have of that counting problem and the additional understanding that I don't ask "trick" questions or questions based on trivia, explain or...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: How to connect to SQL server named instance on a static port

    Have you tried connecting to SQL without the ",<portnumber>" yet?

    At my workplace, we had an issue way back when where the port number was required until our networking team fixed...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Prevent RENAME of a database

    Igor Micev (8/15/2014)


    Brandie Tarvin (8/15/2014)


    What about DDL Triggers? Could those rollback any attempt at renaming a database?

    I have already tried with a DDL trigger on instance level to catch the...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Preventing Duplicate Rows On An Insert

    Why not just use a LEFT OUTER JOIN to check for existence?

    DECLARE @LogId INT, @L INT, @E INT;

    SET @LogId = NULL;

    SET @L = 17;

    SET @E = 9999;

    INSERT INTO t...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Prevent RENAME of a database

    What about DDL Triggers? Could those rollback any attempt at renaming a database?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Compare two columns

    I'm not even seeing the logic between the 3 columns of the original data and the rows that appear to have more than three values.

    Please post your table DDL and...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Backup SQL settings?

    lptech (8/15/2014)


    At least in SQL Server 2014, SSIS packages all won't have to be modified

    YIKES! I forgot about mentioning this. NAS shares, SSIS packages saved on the File level...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 15 posts - 3,151 through 3,165 (of 9,725 total)