Viewing 7 posts - 1 through 7 (of 7 total)
Guess I should contact MS, eh?
October 24, 2003 at 2:51 pm
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...
October 24, 2003 at 2:50 pm
2) You can put the BLOB data in a separate file/filegroup. This allows you to backup that data separately and at...
April 24, 2003 at 12:31 pm
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...
April 24, 2003 at 12:28 pm
Is there a significant performance benefit to building dynamic SQL in a stored procedure instead of from within code?
April 24, 2003 at 9:41 am
It appears that BLOB pages are cached just the same as any other page. Thanks for your help.
The following should answer...
April 1, 2003 at 2:42 pm
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...
March 26, 2003 at 3:39 pm