Viewing 15 posts - 37,621 through 37,635 (of 39,456 total)
Some good threads on this:
Another one somewhere.
Also you have to backup the image db, which is a load. Takes backup and restore time. If you want to do this, I'd...
April 5, 2002 at 1:37 pm
Good suggestions. If you have the app, I'd also do the following:
Run profiler and track the longest running queries that take more than some value (1sec, 10 sec. whatever) to...
April 5, 2002 at 1:23 pm
I'd use a queueing method, not a trigger to do this. Setup your trigger to insert a value in a table that you need. Then setup a DTS package or...
April 5, 2002 at 12:13 pm
What do you mean you "restrictied access"? Can you post the GRANT, ReVOKE or DENY statements?
When you access from another db, what user is being used?
Security is user and...
April 5, 2002 at 11:35 am
April 5, 2002 at 11:12 am
April 4, 2002 at 8:49 pm
If you haven't read this, it's interesting:
http://www.softwaremarketsolution.com/
from the maintainer of http://www.joelonsoftware.com
Steve Jones
April 4, 2002 at 8:41 pm
Is that true? I thought all comms were across that port. Need to check this out.
Steve Jones
April 4, 2002 at 8:33 pm
There is a white paper on performance tuning here:
http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp
I think there will be a variety of factors. It seems that the write size of Windows will have something to do...
April 4, 2002 at 6:14 pm
You can by storing the id value in a @var and then incrementing by selecting the min(id) where id > @id.
Steve Jones
April 4, 2002 at 2:21 pm
Or send in all the values for the params to one procedure and have that one call the appropriate procedure to do what you want.
Steve Jones
April 4, 2002 at 2:13 pm
April 4, 2002 at 2:06 pm
It was buggy and IMHO, that is why they made it the non-default.
Probably a registry setting, but I have no idea which one.
Steve Jones
April 4, 2002 at 2:05 pm
We do this with categories here at SSC.
create table Category
( categoryid int
, categoryname varchar(20)
, parentcatid int
)
insert category 1, 'SQL 2000', 0
insert category 2, 'Programming', 0
insert category...
April 4, 2002 at 1:09 pm
Viewing 15 posts - 37,621 through 37,635 (of 39,456 total)