Forum Replies Created

Viewing 15 posts - 6,181 through 6,195 (of 9,715 total)

  • RE: Temp DB

    If you are relying on default sizes (not altering them) when you create the databases, all you have to do is look at the size of the Model db files....

    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: SQL Server Agent Issue.

    happycat59 (3/25/2011)


    I don't think that you will be able to open the packages with BIDS 2005 that easily.

    So true. When you save a package in BIDS 2008, even 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.

  • RE: Are the posted questions getting worse?

    GSquared (3/25/2011)


    jcrawf02 (3/25/2011)


    I just want to know who bought a Surface table to play on...

    Ooooohhhhh, I WISH!!! That was the first thing I thought of when I saw 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: Are the posted questions getting worse?

    At risk of turning this into a technical discussion again. Aren't bulk insert operations minimally logged? Haven't they been since at least SQL 2000?

    I ask because a MS document I'm...

    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: Problem: how to realize custom order

    GSquared (3/25/2011)


    ... but more rules are needed to have a complete solution...

    Gus, you have a talent for seeing the same concerns as I do, but articulating them much better. Thank...

    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: Problem: how to realize custom order

    Gianluca Sartori (3/25/2011)


    WayneS (3/25/2011)


    From what I see....

    Fill up a "group queue" with two groups, in order of the routeCode column.

    Return one row from each group, in order of the routePos...

    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: Problem: how to realize custom order

    Gianluca Sartori (3/25/2011)


    Let me try to rephrase this: we have X groups with Y elements each.

    We have to pull out data taking one row from group 1, one row from...

    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: Shrink Database in Simple Recovery Mode

    GilaMonster (3/25/2011)


    The IO docs I referred you to should make it clear that SQL does not move data from log to data file during a checkpoint, and given that they...

    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: Shrink Database in Simple Recovery Mode

    To get more input, I #SQLHelp tweeted the question about the transaction log to data file that I'd posted. I got an immediate response that SQL does indeed work that...

    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: Problem: how to realize custom order

    Please try to clarify (in words, without reposting the data output) what the order logic is. Remember, we don't know your data as well as you do, so you might...

    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?

    GSquared (3/25/2011)


    GilaMonster (3/25/2011)


    I just realised I don't have an April Fools day blog post planned. 🙁

    So start a completely serious post with, "I had this idea for an April Fools...

    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: Shrink Database in Simple Recovery Mode

    GilaMonster (3/25/2011)


    Brandie Tarvin (3/25/2011)


    GilaMonster (3/25/2011)


    The changed records can have long since being written to stable media by the time the associated log records are truncated. Depends what else is happening,...

    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?

    Fal (3/25/2011)


    I just popped along to the Guiness World Records website to see if we could lodge The Thread under a Longest Web Thread category or similar. There doesn'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.

  • RE: Shrink Database in Simple Recovery Mode

    GilaMonster (3/25/2011)


    The changed records can have long since being written to stable media by the time the associated log records are truncated. Depends what else is happening, what else those...

    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: Shrink Database in Simple Recovery Mode

    GilaMonster (3/23/2011)


    Brandie Tarvin (3/23/2011)


    The act of consuming the cookies (I.E., sticking the data into the data file) makes the affected part of the plate available for checkpointing.

    Data doesn't move...

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