Viewing 15 posts - 37,891 through 37,905 (of 39,498 total)
March 1, 2002 at 1:55 pm
np, however since there was already a response in the other one, I left it there.
If I get a chance, I'll move it here.
Steve Jones
March 1, 2002 at 1:54 pm
What about non-clustered index? It will also help. What type of queries? Can you post a sample.
Steve Jones
March 1, 2002 at 11:38 am
Vote 3 for Anatares.
Keep in mind this also allows you to distribute these pdfs to other web servers or file servers if the load rises. On the Internet, you could...
March 1, 2002 at 11:36 am
March 1, 2002 at 11:35 am
So have you ever taped them in place?
I give my 9 yr old a few sentences to write to keep him focused.
Steve Jones
March 1, 2002 at 11:33 am
Pls don't cross post. We check all the forums.
answer in the other post.
Steve Jones
March 1, 2002 at 11:33 am
March 1, 2002 at 11:30 am
A few suggestions.
1. copy the files to the local drive using some other process.
2. I map drives by loggin in as the SQL Agent/Server account and create the mapping. It...
March 1, 2002 at 11:20 am
March 1, 2002 at 11:17 am
Another apology. Not that much of a web guy. You might try posting this at 4guysfromrolla.com and seeing if they have an idea.
Steve Jones
March 1, 2002 at 11:16 am
update cd
SET TotalPaidIn = TotalPaidIn + cp.receiptamount
, BalanceOnHand = BalanceOnHand + cp.receiptamount
from casedata cd
inner join currentpostings cp
on cd.casenumber = cp.casenumber
WHERE cp.batchid = @batchid
Steve Jones
March 1, 2002 at 11:14 am
Tend to agree with Antares. If these are different development efforts, might be easier to have one server with mutliple databases. Less admin and licensing as well.
Steve Jones
March 1, 2002 at 11:11 am
March 1, 2002 at 11:10 am
Tend to agree with Andy. I usually make a role as soon as I create the database for the general access for that database. Might be webusers, might be MyAppUsers,...
March 1, 2002 at 11:09 am
Viewing 15 posts - 37,891 through 37,905 (of 39,498 total)