Forum Replies Created

Viewing 15 posts - 1,366 through 1,380 (of 9,720 total)

  • RE: sql backup

    It also depends on if you're doing a FULL, DIFFERENTIAL, or TRANSACTION LOG backup. Diffs will always be faster than FULLs unless things change really fast and really often, 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.

    October 19, 2016 at 4:23 am

    #1907360

  • RE: log is full due to Availability Replica

    rkrpat (10/18/2016)

    Please help in finding out the root cause as why DR node which is Asynchronous is affecting the primary replica

    There are two things that could be causing your issue....

    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.

    October 19, 2016 at 4:19 am

    #1907358

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (10/18/2016)

    Just had a Blast from the past

    😎

    Wait... 11 - 13k of RAM? 32-bit?

    Where did you dig up this dinosaur? @=)

    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.

    October 18, 2016 at 11:40 am

    #1907228

  • RE: With recompile in the master stored proc

    You are comparing apples to oranges. SSIS is set up differently than SSMS. We advise you hire a consultant to come in and look at your environment to give 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.

    October 18, 2016 at 11:38 am

    #1907227

  • RE: Are the posted questions getting worse?

    BWFC (10/18/2016)

    jasona.work (10/18/2016)

    BWFC (10/18/2016)

    jasona.work (10/18/2016)

    Brandie Tarvin (10/18/2016)

    What a morning. SSC just broke my heart.

    I see an article about time traveling listed in the newsletter. Get ready to read it 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.

    October 18, 2016 at 8:50 am

    #1907165

  • RE: Are the posted questions getting worse?

    Do people really not know how to look at their email headers?

    I just got an email from someone I don't recognize. So I popped open the message options 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.

    October 18, 2016 at 8:48 am

    #1907164

  • RE: Are the posted questions getting worse?

    Here you, Threadzians. Have a palate cleanser.

    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.

    October 18, 2016 at 7:38 am

    #1907137

  • RE: With recompile in the master stored proc

    river1 (10/18/2016)

    Hello,

    The ssis as a loop also. It is a forearm loop container. It loops the same number of times as the sp.

    Also, tests are being executed on the same...

    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.

    October 18, 2016 at 6:45 am

    #1907120

  • RE: Are the posted questions getting worse?

    BWFC (10/18/2016)

    jasona.work (10/18/2016)

    Brandie Tarvin (10/18/2016)

    What a morning. SSC just broke my heart.

    I see an article about time traveling listed in the newsletter. Get ready to read it and realize, it's...

    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.

    October 18, 2016 at 6:05 am

    #1907109

  • RE: With recompile in the master stored proc

    Brandie Tarvin (10/18/2016)

    river1 (10/17/2016)

    Can a warning be considered as not success ?

    If I am reading this correctly, you aren't even executing the procs in the same manner in the SSIS...

    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.

    October 18, 2016 at 5:59 am

    #1907108

  • RE: With recompile in the master stored proc

    river1 (10/17/2016)

    Hello, Thank you for the feedback. Both on same machine. The ssis package performed much better then the script. With the package I take 16 minutes. With the script...

    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.

    October 18, 2016 at 5:58 am

    #1907107

  • RE: Are the posted questions getting worse?

    What a morning. SSC just broke my heart.

    I see an article about time traveling listed in the newsletter. Get ready to read it and realize, it's not talking about building...

    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.

    October 18, 2016 at 5:25 am

    #1907098

  • RE: Are the posted questions getting worse?

    GilaMonster (10/17/2016)

    Anyone seen the crystal ball?

    http://www.sqlservercentral.com/Forums/FindPost1826636.aspx

    No. But I'll give it a shot. Last time I saw behavior like this, it was because SSIS was running on an app 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.

    October 17, 2016 at 11:52 am

    #1906960

  • RE: With recompile in the master stored proc

    Are you actually executing SSIS on the same exact machine / instance in SSIS as you are executing the procs in SSMS?

    And, if so, how are you executing SSIS?

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

    October 17, 2016 at 11:51 am

    #1906959

  • RE: Are the posted questions getting worse?

    Ed Wagner (10/17/2016)

    Phil Parkin (10/17/2016)

    Brandie Tarvin (10/17/2016)

    rodjkidd (10/17/2016)

    So hands up who loves the idea of a production db being called Test_Autos on a server that was the test server...

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

    October 17, 2016 at 8:33 am

    #1906884

Viewing 15 posts - 1,366 through 1,380 (of 9,720 total)