Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: recovery interval

    Guess I should contact MS, eh?

  • RE: recovery interval

    I have read BOL numerous times... and all transactions are very short in duration. What I see happening is completely contradictory. I have trace flag 3502 on and...

  • RE: Blob Datatypes and Performance Issues

    quote:


    2) You can put the BLOB data in a separate file/filegroup. This allows you to backup that data separately and at...

  • RE: Blob Datatypes and Performance Issues

    Couple of things I've learned, I'm working on a similar project. I'm assuming you're running SS 2000.

    1) Using the bulk-logged recovery model will minimally log BLOB inserts (see BOL...

  • RE: How to Build Dynamic Stored Procedures

    Is there a significant performance benefit to building dynamic SQL in a stored procedure instead of from within code?

  • RE: BLOBs and buffer cache

    It appears that BLOB pages are cached just the same as any other page. Thanks for your help.

    quote:


    The following should answer...

  • RE: Should you buy a SAN?

    Once operating on a SAN, does it still really matter that you keep log and data on separate drives? Would anyone go as far as to connect them via...

Viewing 7 posts - 1 through 7 (of 7 total)