Forum Replies Created

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

  • 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

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

    So I'm googling to see if there's a way to get a replacement CD and notice an odd link. I open the link up in another window and see 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.

    March 25, 2011 at 5:11 am

    #1303486

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

    I'm trying to avoid spending money until I check my skill levels. Otherwise, I would have already purchased Transcender.

    I really wish I could find my 70-441 CD, but it appears...

    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 4:56 am

    #1303479

  • RE: Blocked process is attempting to [create procedure sys.sp_sproc_columns...]

    You're welcome. But I too would love to know the exact explanation, if there is one. So if anyone has anything more specific, feel free to add to this thread!

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

    #1303478

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