Forum Replies Created

Viewing 15 posts - 7,786 through 7,800 (of 9,707 total)

  • RE: Buffer Pool information/usage

    Whoops, I must have mixed up those two fields when I read the snippet. My bad.

    What is the priority on your Server Properties Processors tab? And what else do you...

  • RE: Are the posted questions getting worse?

    GilaMonster (7/29/2010)


    If you look, it didn't go suspect. It went recovery_pending. That's because the corruption was encountered while opening the file. To get it suspect, the corruption has to...

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

    Dana Bibeault (7/29/2010)


    Can't see them in the user GUI. I can see them as administrator on my gui and on the server.

    strangely, if the user goes to another PC,...

  • RE: Are the posted questions getting worse?

    GilaMonster (7/29/2010)


    Results of test:

    ....

    If you're interested in repo:

    ....

    -- open mdf in hex editor at this point and overwrite part of the first couple pages.

    Is this what you did to...

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

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

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

  • RE: Are the posted questions getting worse?

    DOH. Sorry. :pinch:

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

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

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

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

  • RE: Today's Random Word!

    Hee. @=)

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

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

Viewing 15 posts - 7,786 through 7,800 (of 9,707 total)