Forum Replies Created

Viewing 15 posts - 2,971 through 2,985 (of 9,715 total)

  • RE: Best way to migrate data from 2005 to 2008R2 env

    The other possibility (correct me if I'm wrong, everyone) is to use the DTSX Import Wizard from the 2008R2 server to grab the data from the 2005 server. It won'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.

    January 13, 2015 at 6:44 am

    #1769787

  • RE: Excel Hell using SSIS

    Koen Verbeeck (1/13/2015)

    You can also set TypeGuessRows to 0 in the registry. It then scans the first 60,000 rows or so.

    WOW. I did not know about that hack. Thanks, Koen.

    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 13, 2015 at 6:39 am

    #1769786

  • RE: How to Loop the unmatched rows data from two tables in sqlserver 2012

    Can you try explaining in more English and less code what you're trying to accomplish?

    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 13, 2015 at 6:37 am

    #1769785

  • RE: Copy from "edit top N rows" with an auto increment field

    masoudk1990 (1/13/2015)

    I know how to copy and paste data from one table to another table with INSERT and SELECT query.

    I just want to know is it possible to do this...

    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 13, 2015 at 6:36 am

    #1769784

  • RE: SSIS-Stored-Packages via Job: Logging fails

    ElKapy (1/12/2015)

    Hello there,

    I have a some SSIS-Stored-Packages. Running these jobs via "Run package", works fine, inluding logging.

    Running the packages by Job, however, works also fine, except the Logging!

    Looking in 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.

    January 13, 2015 at 6:33 am

    #1769782

  • RE: How to get auto-increment column in SELECT query

    You also need to be careful if you are inserting into a column that already has the identity property set. Check out the SET IDENTITY_INSERT statement in Books Online.

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

    January 13, 2015 at 6:32 am

    #1769781

  • RE: Are the posted questions getting worse?

    Wow. I haven't posted to The Thread since last year... Anyway, hello again everyone.

    Me updates... I'm hoping to convince my bosses to pay for PASS this year since 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 13, 2015 at 6:17 am

    #1769777

  • RE: Performance issue due to database mirroring?

    Lynn Pettis (1/12/2015)

    Brandie Tarvin (1/12/2015)

    Lynn Pettis (1/12/2015)

    Brandie, just curious, when you are importing the file how is it inserted into the table(s)? Does the data go in sequentially on...

    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 12, 2015 at 11:24 am

    #1769592

  • RE: Performance issue due to database mirroring?

    The Redneck DBA (1/12/2015)

    Brandie Tarvin (1/12/2015)

    And the verdict is in. It was the mirroring after all. Specifically, it was synchronous mode. When I set it to asnychronous, it only took...

    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 12, 2015 at 11:17 am

    #1769588

  • RE: Performance issue due to database mirroring?

    Lynn Pettis (1/12/2015)

    Brandie, just curious, when you are importing the file how is it inserted into the table(s)? Does the data go in sequentially on the clustered index? ...

    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 12, 2015 at 10:48 am

    #1769581

  • RE: Performance issue due to database mirroring?

    And the verdict is in. It was the mirroring after all. Specifically, it was synchronous mode. When I set it to asnychronous, it only took 2 and 1/2 hours 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 12, 2015 at 9:07 am

    #1769539

  • RE: Performance issue due to database mirroring?

    GilaMonster (1/12/2015)

    There could also be some effects from the write latency if the log file on the mirror is slow.

    When you have synchronous mirroring, the minimum duration for a transaction...

    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 12, 2015 at 6:52 am

    #1769482

  • RE: Performance issue due to database mirroring?

    george sibbald (1/12/2015)

    Brandie, just to confirm, you have enterprise edition to enable the use of asynchronous? If you can tolerate some data loss, would log-shipping be an alternative?

    No. We cannot...

    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 12, 2015 at 6:42 am

    #1769478

  • RE: Performance issue due to database mirroring?

    GilaMonster (1/12/2015)

    No.

    http://msdn.microsoft.com/en-us/library/ms189061.aspx

    Thank you, Gail.

    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 12, 2015 at 6:08 am

    #1769466

  • RE: Performance issue due to database mirroring?

    I can find all sorts of references about switching the safety mode in the GUI, but I only found one reference to using t-sql and it refers to the PARTNER...

    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 12, 2015 at 5:38 am

    #1769460

Viewing 15 posts - 2,971 through 2,985 (of 9,715 total)