Forum Replies Created

Viewing 9 posts - 31 through 39 (of 39 total)

  • RE: In the Real World - Lost Data Chains

    Steve,

    Quite an interesting story. Sounds like the week from Hell. I admire your persistance in solving this problem.

    I suspect SQL Server was able to rebuild the page pointers...

  • RE: The SQL Server Black Box

    Brian,

    Liked your article. I also like your book SQL Server 2000 For Experienced DBAs.

    My Blackbox trace alternates between writing to blackbox.trc and blackbox_1.trc. How does this correlate with...

  • RE: Procedure cache - recompile problem

    If you can provide a documented source of your bitmap, I would be interested in researching it. In particular, I would like to learn more about the NO_BROWSETABLE, FORCEPLAN,...

  • RE: Procedure cache - recompile problem

    Leif,

    Better grab a fresh cup of coffee. This is going to be a lengthy post. Here is my interpretation of what is happening.

    The setopts column in syscacheobjects is...

  • RE: Memory usage

    This is a common point of confusion. SQL Server only releases memory on reboots and when the operating systems requests memory. As long as the OS is satisfied,...

  • RE: Design Question

    Len,

    I find your response reasonable and agree with your conclusion.

    That Larry guy was my evil twin cousin who goes by the same name, but often writes contrarian email just to...

  • RE: Procedure cache - recompile problem

    Kalen Delaney, author of Inside SQL Server 2000, wrote a series of articles (Dec. 2002, Feb. 2001, & Jan. 2000) in SQL Server Magazine regarding recompilations. You may find...

  • RE: Senior MS SQL Server DBA , Alexandria, VA

    This company is clear. They are trying to make their expectations explicit. They want a strong professional and haven't found one. So I agree with Steve. ...

  • RE: Design Question

    This practice seems sloppy, and is probably due to insufficient knowledge on the part of the developer. Some friendly education may be appropriate.

    On the other hand, there may be...

Viewing 9 posts - 31 through 39 (of 39 total)