Viewing 15 posts - 35,191 through 35,205 (of 39,720 total)
There are a few possibilities:
1. nothing was "happening" in the db as far as writes were concerned, so even though the files where open, the mdf and ldf matched, so...
February 24, 2004 at 10:33 am
The NT/W2K architecture allows a 4GB virtual memory space for the server, 2GB for the OS and 2GB for any particular application. This can be altered with the 3GB switch...
February 24, 2004 at 10:24 am
Not sure how you'd do it in ASP, bascially you need some object to go through and "test" the URL. It would be similar to consuming a web service in...
February 24, 2004 at 10:19 am
Do you mean dead URL links? You'd need a cursor to run through all the values in the table and test each link. I'd do this with VB, get a...
February 24, 2004 at 9:34 am
February 24, 2004 at 9:31 am
Personally I think it's a bad idea (http://www.sqlservercentral.com/columnists/sjones/wp_encryption.asp), but if you have to do it, then key management will be the biggest headache. For live data as well as...
February 24, 2004 at 9:29 am
Good suggestions. We're fighting the bugs with the change in the forums, but these are good ideas for when we convert the rest of the site to ASP.NET. They make sense...
February 24, 2004 at 9:21 am
Use a table to store the message and then include that? Could us a
create table msg (spid int, mymsg varchar( 100))
and put a row in for each line of...
February 23, 2004 at 9:52 am
Good idea, we'll look at getting that setup. For now a search on "worst practices" will turn them up.
February 23, 2004 at 9:48 am
I actually hadn't planned on the followup for "how to do this", but I've gotten a bunch of responses, so maybe I should.
I've got a couple of systems that I've...
February 23, 2004 at 9:44 am
I've tended to not defrag those folders where SQL data is located. My suspicion is that it would slow down IO, but it shouldn't affect the SQL Server, unless you...
February 23, 2004 at 9:37 am
Apologies. This is a strange one that Andy has been working to track down. Seems to work with IE6 and Mozilla 1.6 for me very consistently.
February 23, 2004 at 9:36 am
Even in simple mode, this will be logged in one long transaction. Once it completes, the checkpoint will wipe it out, but until then it's all getting written.
I'd break it...
February 20, 2004 at 10:30 am
Viewing 15 posts - 35,191 through 35,205 (of 39,720 total)