Forum Replies Created

Viewing 15 posts - 7,801 through 7,815 (of 9,715 total)

  • RE: Buffer Pool information/usage

    I'm not sure setting Min Memory to the same amount as Max Memory is an optimal solution, SQLBuddy. Once SQL reaches that 3GB, it won't free up memory from 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.

    July 29, 2010 at 8:45 am

    #1199840

  • RE: linked server catalogs not showing on client SSMS.

    Is the problem that he can't see them in the GUI or that he can't use them or both?

    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.

    July 29, 2010 at 8:34 am

    #1199828

  • RE: Help with Sql Stroge switch

    It depends on what they're actually doing. Are they swapping old disks for new disks? Or just the software used to control the disks?

    If the later, they'll backup the data...

    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.

    July 29, 2010 at 8:31 am

    #1199826

  • RE: Are the posted questions getting worse?

    DOH. Sorry. :pinch:

    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.

    July 29, 2010 at 8:13 am

    #1199816

  • RE: Today's Random Word!

    crookj (7/29/2010)

    dbowlin (7/29/2010)

    Let's do the timewarp again:cool:

    It's just a jump to the left

    And then a step to the right

    With your hands on your hips

    You bring your knees in tight

    But it's...

    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.

    July 29, 2010 at 7:59 am

    #1199807

  • RE: Are the posted questions getting worse?

    Paul White NZ (7/29/2010)

    BTW I say 'darn near impossible' because I have never tried to back up the tail of the log for a damaged simple-mode database. I would...

    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.

    July 29, 2010 at 7:57 am

    #1199804

  • RE: Connections & Sessions

    ggjjbb1983 (7/28/2010)

    1. 3. For example, how many sessions can a connection have and vice versa.

    Depends on how your server is set up, how many CPUs you have, how heavy 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.

    July 29, 2010 at 7:20 am

    #1199776

  • RE: Connections & Sessions

    I could be wrong about this, but this is how I understand it.

    Sessions "contain" connections.

    A query can connect with multiple threads to the server to assist with performance and...

    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.

    July 29, 2010 at 7:10 am

    #1199766

  • RE: Today's Random Word!

    Hee. @=)

    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.

    July 29, 2010 at 6:56 am

    #1199750

  • RE: Are the posted questions getting worse?

    GilaMonster (7/29/2010)

    What probably would work is, at the point of the 'oops', take the DB offline, copy the files elsewhere (both mdf and ldf), attach as new DB and mark...

    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.

    July 29, 2010 at 6:54 am

    #1199749

  • RE: Today's Random Word!

    Tom.Thomson (7/28/2010)

    Surely solvable by using dbcc timewarp? After all, time must be cheap if is unboundeded and has whatever flow charecteristics one chooses.

    Someone explain this to me. Is 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.

    July 29, 2010 at 6:31 am

    #1199735

  • RE: Today's Random Word!

    Ray K (7/28/2010)

    I don't sing, although considering the trouble I've been having trying to find someone to help with demos (I'm a songwriter, too!), I might have 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.

    July 29, 2010 at 6:27 am

    #1199733

  • RE: Are the posted questions getting worse?

    BBQ Mythbusters Style.

    Tenderize the meat with TNT!

    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.

    July 28, 2010 at 12:18 pm

    #1199433

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (7/28/2010)

    Lynn Pettis (7/28/2010)

    Brandie Tarvin (7/28/2010)

    Suddenly I'm wondering if it would be worth my time to write up my "Nitty-Gritty of Database Backups" SQL Saturday presentation into a series of...

    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.

    July 28, 2010 at 11:29 am

    #1199401

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (7/28/2010)

    Wait, you can't back up a log in simple mode? Can't I stop the service and just copy the file? :w00t:

    Sure. But before you start 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.

    July 28, 2010 at 10:58 am

    #1199383

Viewing 15 posts - 7,801 through 7,815 (of 9,715 total)