Forum Replies Created

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

  • 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

  • RE: Are the posted questions getting worse?

    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 production server details were also sent...

    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 7:54 am

    #1906867

  • RE: Are the posted questions getting worse?

    Grant Fritchey (10/17/2016)

    Brandie Tarvin (10/17/2016)

    So who else is going to be watching Dirk Gently's Holistic Detective Agency when it comes out?

    Read those when I was much younger. Which network 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 7:05 am

    #1906848

  • RE: Are the posted questions getting worse?

    So who else is going to be watching Dirk Gently's Holistic Detective Agency when it comes out?

    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 6:54 am

    #1906842

  • RE: Are the posted questions getting worse?

    Sean Lange (10/13/2016)

    Brandie Tarvin (10/13/2016)

    ChrisM@Work (10/13/2016)

    Brandie Tarvin (10/13/2016)

    GilaMonster (10/13/2016)

    Grant Fritchey (10/13/2016)

    Sean Lange (10/13/2016)

    WOW...http://www.sql-datatools.com/2016/05/sql-queries-tuning-and-optimization.html

    This is supposed to be a list of things to do to optimize queries. While some of these...

    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 14, 2016 at 6:15 am

    #1906547

  • RE: Combining AlwaysOn Groups With Failover Cluster Instances

    keeyu2 (10/14/2016)

    My environment is not as complicated. I have one FCI in one data center and want to replicate it to another datacenter using AG.

    Then you need to have...

    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 14, 2016 at 6:12 am

    #1906545

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