Forum Replies Created

Viewing 15 posts - 4,771 through 4,785 (of 9,726 total)

  • RE: Today's Random Word!

    electricity

    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.

    January 30, 2012 at 7:32 am

    #1439984

  • RE: Replication as a partial DRS

    SQLKnowItAll (1/27/2012)

    Brandie Tarvin (1/27/2012)

    SQLKnowItAll (1/27/2012)

    If one of my applications cannot connect to a db for any reason, I need to have the best way to handle that situation. Depending...

    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.

    January 30, 2012 at 7:26 am

    #1439977

  • RE: Replication as a partial DRS

    SQLKnowItAll (1/27/2012)

    If one of my applications cannot connect to a db for any reason, I need to have the best way to handle that situation. Depending on the disaster...

    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.

    January 27, 2012 at 12:46 pm

    #1439589

  • RE: Replication as a partial DRS

    Jared,

    Actually, I'm approaching this from the POV of someone who did DR & BC design at a previous employer far far before I ever became a DBA.

    It's obvious to...

    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.

    January 27, 2012 at 12:15 pm

    #1439569

  • RE: Replication as a partial DRS

    Reasons why I disagree with Replication as a DR solution.

    1) Latency. Depending on your replication setup, you could have more latency in it than in your normal database backups. Which...

    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.

    January 27, 2012 at 11:53 am

    #1439557

  • RE: Msg 7412, Sev 16, State 1, Line 75

    I'm reaching, but ... Does this help? http://guomingli.blogspot.com/2010/03/ole-db-provider-sqlncli-for-linked.html

    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.

    January 27, 2012 at 11:07 am

    #1439541

  • RE: Are the posted questions getting worse?

    Anybody here backup with BizTalk?

    http://www.sqlservercentral.com/Forums/Topic1242925-391-1.aspx#bm1242974

    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.

    January 27, 2012 at 10:55 am

    #1439538

  • RE: Are the posted questions getting worse?

    Someone help me. My brain is leaking.

    I think I need to stop answering forum questions for the day. My fingers and my head don't agree with each other, 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.

    January 27, 2012 at 9:36 am

    #1439477

  • RE: Msg 7412, Sev 16, State 1, Line 75

    Are your backups native SQL backups or are they using BizTalk to backup?

    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.

    January 27, 2012 at 9:33 am

    #1439473

  • RE: Msg 7412, Sev 16, State 1, Line 75

    CharlieL (1/27/2012)

    The backup that first failed was at midnight, when the server is quiet, so I don't think it's down to the server being busy.

    Wait. You're using a Linked Server...

    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.

    January 27, 2012 at 9:18 am

    #1439459

  • RE: Effect of Clustered Index Updates

    patrickmcginnis59 (1/27/2012)

    Brandie Tarvin (1/27/2012)

    If your updates are going to cause a lot of fragmentation, and frequent fragmentation at that, then it is advised you check your database maintenance jobs 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.

    January 27, 2012 at 7:45 am

    #1439372

  • RE: Store procedure

    Krasavita (1/27/2012)

    I have a lot of sp and I want provide access to all sp with execute,is there way to select all of them at the same time or I...

    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.

    January 27, 2012 at 7:34 am

    #1439365

  • RE: Are the posted questions getting worse?

    GSquared (1/27/2012)

    Brandie Tarvin (1/27/2012)

    So, question of the day. How do you help people who refuse to be helped? People who are resistant to your suggestions of "test it" or "try...

    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.

    January 27, 2012 at 7:32 am

    #1439363

  • RE: Combining Simple Count Queries

    frfernan (1/27/2012)

    trying to understand and domain some code is like trying to map a room in the dark, extending the hand and discovering a needle because it hurts.

    That 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.

    January 27, 2012 at 7:23 am

    #1439355

  • RE: Effect of Clustered Index Updates

    If your updates are going to cause a lot of fragmentation, and frequent fragmentation at that, then it is advised you check your database maintenance jobs and verify you are...

    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.

    January 27, 2012 at 7:19 am

    #1439352

Viewing 15 posts - 4,771 through 4,785 (of 9,726 total)