Viewing 15 posts - 37,516 through 37,530 (of 39,758 total)
There are some posts here. I noticed a delay in SQL Server getting the update, I think 40 sec on SQL 2K, W2K.
Search these forums and you'll see a thread.
Steve...
July 1, 2002 at 12:36 pm
In past versions, I used to do this, but only if the SQL Server is STOPPED. IF the SQL Server continues to run, then you will probably not be able...
July 1, 2002 at 9:16 am
Should be fine. If you need to grant permissions to everyone, you will need to reenable it.
Steve Jones
July 1, 2002 at 9:14 am
Glad you liked it and thanks everyone for the comments.
I've got part 2 out now and have a part 3, which addresses some header comments in the next part.
Steve...
July 1, 2002 at 9:05 am
Thanks for all the comments. This is something that I have found helpful as well and hopefully others will adopt something similar to standardize their environments.
Steve Jones
July 1, 2002 at 8:54 am
There are a few discussions on this in this forum. Search for image storage and see.
My vote, store the doc in the filesystem and a reference in SQL, but others...
June 28, 2002 at 4:50 pm
Are you set to repair the dbs? If so, remove this.
check the maintenance plan logs as well and post anything you find.
Steve Jones
June 28, 2002 at 12:57 pm
What do you mean? The page size for memory is set with NT.
Do you mean the number of pages in memory? Not sure about that one.
Steve Jones
June 28, 2002 at 12:51 pm
SQL will take all the memory it thinks it needs to complete a query. If this is a large query, SQL may be caching the data to speed the update....
June 28, 2002 at 11:27 am
iif( condition, true, false)
translates to
if condition
begin
true statements
end
else
begin
false statements
end
Steve Jones
June 28, 2002 at 10:53 am
Are you looking at advanced options in sp_configure? There is nothing on lock timeout? Or perhaps query timeout?
Steve Jones
June 28, 2002 at 10:16 am
Good comment. The tests can teach you what you do not know, but they also let you validate what you do.
However, I do think they should be tougher.
Steve Jones
June 28, 2002 at 10:12 am
Viewing 15 posts - 37,516 through 37,530 (of 39,758 total)