Forum Replies Created

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

  • 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

  • RE: Are the posted questions getting worse?

    Are you people TRYING to kill my inbox? @=)

    Looking forward to your secret book project, 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.

    March 25, 2011 at 4:52 am

    #1303476

  • RE: Restore

    Tara-1044200 (3/24/2011)

    everything looks normal in the error logs except this message which i think is informational.

    SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part...

    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 24, 2011 at 12:30 pm

    #1303156

  • RE: Page Number question

    Thanks, Gail. That helps.

    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 24, 2011 at 12:28 pm

    #1303155

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