Forum Replies Created

Viewing 15 posts - 6,196 through 6,210 (of 9,728 total)

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

    March 25, 2011 at 10:52 am

    #1303751

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

    March 25, 2011 at 8:58 am

    #1303651

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

    March 25, 2011 at 8:48 am

    #1303641

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

    March 25, 2011 at 8:40 am

    #1303632

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

    March 25, 2011 at 8:00 am

    #1303610

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

    March 25, 2011 at 7:57 am

    #1303606

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

    March 25, 2011 at 7:39 am

    #1303586

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

    March 25, 2011 at 7:19 am

    #1303561

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

    March 25, 2011 at 6:58 am

    #1303541

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

    March 25, 2011 at 6:49 am

    #1303532

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

    March 25, 2011 at 6:45 am

    #1303528

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

    March 25, 2011 at 6:17 am

    #1303516

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

    March 25, 2011 at 6:00 am

    #1303505

  • RE: Practice Questions for 70-441 & 70-442

    Richard Warr (3/25/2011)

    It looks as though that's a bit of a "spam" page. There's no evidence that the product actually exists, just an "Enter your email address and we'll be...

    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.

    March 25, 2011 at 5:28 am

    #1303491

  • RE: Practice Questions for 70-441 & 70-442

    No, it's not an official MS link. I didn't include the link because I don't want to give them business.

    I did find the MS link though at http://www.microsoft.com/learning/en/us/training/format-books-support.aspx.

    And sure enough,...

    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.

    March 25, 2011 at 5:24 am

    #1303490

Viewing 15 posts - 6,196 through 6,210 (of 9,728 total)