Forum Replies Created

Viewing 15 posts - 6,091 through 6,105 (of 9,715 total)

  • RE: Basic concat over 500 times slower than straight select?

    Jeff Moden (4/13/2011)


    Ninja's_RGR'us (4/13/2011)


    Brandie Tarvin (4/13/2011)


    Does the order really matter?

    It actually could. If it fails to finish in the allowed time I need to be able to start back...

    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: Basic concat over 500 times slower than straight select?

    Ninja's_RGR'us (4/13/2011)


    Brandie Tarvin (4/13/2011)


    Does the order really matter?

    It actually could. If it fails to finish in the allowed time I need to be able to start back where it...

    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: Basic concat over 500 times slower than straight select?

    Does the order really matter?

    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: Basic concat over 500 times slower than straight select?

    Ninja's_RGR'us (4/13/2011)


    This thread is not how can I make this work, it's about why the heck does this concat take so long.

    Ninja, I only asked because I thought the concat...

    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: Are the posted questions getting worse?

    Craig Farrell (4/12/2011)


    Chad Crawford (4/12/2011)


    Craig Farrell (4/12/2011)


    Personal side note: OMGWTFBBQ. Today is annoying. I've got a failure in QA I can't reproduce in Dev with 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.

  • RE: Are the posted questions getting worse?

    ALZDBA (4/13/2011)


    I'm infected too 😀

    That is an adorable avatar!

    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: Are the posted questions getting worse?

    Craig Farrell (4/12/2011)


    Personal side note: OMGWTFBBQ. Today is annoying. I've got a failure in QA I can't reproduce in Dev with the same load files. Now 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.

  • RE: Unified LOB Programming Model

    Sean Lange (4/12/2011)


    Brandie Tarvin (4/12/2011)


    The context is this:

    RE: datatypes discussion


    When you specific MAX, the data types can store the same size data as text, ntext, and image types (up 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.

  • RE: Basic concat over 500 times slower than straight select?

    Silly question, why not stick the results into a Temp table, then haul out the commands on a line by line basis, since you have so many tables to deal...

    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: Command timeout from .net application

    thulani.moyana 79207 (4/12/2011)


    To Brandie: I think the remote connection timeout is used by the SSMS when connecting to other servers not the application. Please verify.

    So far as I know, 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: Basic concat over 500 times slower than straight select?

    CirquedeSQLeil (4/12/2011)


    Brandie Tarvin (4/12/2011)


    Hey, Ninja, I just realized that Varchar(MAX) isn't big enough to handle a database with a lot of tables. I've tried it on two of my "larger"...

    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: Basic concat over 500 times slower than straight select?

    Hey, Ninja, I just realized that Varchar(MAX) isn't big enough to handle a database with a lot of tables. I've tried it on two of my "larger" databases (object-wise, not...

    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: Basic concat over 500 times slower than straight select?

    I'm curious. Why does a simple concat need variable = variable + string logic? I only ever use that when I'm COALESCING or looping (Cursor or While).

    What are 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: Unified LOB Programming Model

    The context is this:

    RE: datatypes discussion


    When you specific MAX, the data types can store the same size data as text, ntext, and image types (up to 2 gigabytes) but process...

    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: Are the posted questions getting worse?

    WayneS (4/12/2011)


    Brandie Tarvin (4/12/2011)


    I think this cursor suits Stefan's needs best.

    DECLARE OMG_NotAnotherCursor CURSOR GLOBAL_SCREAM BACKWARD_FACING

    STATIC_THE_SUPERHERO PESSIMISTIC DB_LOCKDOWN

    FOR

    SELECT Superpower

    FROM dbo.JusticeLeague

    WHERE SupType = 'Lightning'

    OPEN OMG_NotAnotherCursor

    FETCH LAST FROM OMG_NotAnotherCursor

    ...

    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 - 6,091 through 6,105 (of 9,715 total)