Are you using TRUNCATE or DELETE?
Is COGNOS a linked server, or do you use OPENQUERY()?
If you provided the query (or a sample of the type of query) that is giving
you problems, we may be able to give you more pointed assistance. Without
that, any advice here is just a 'shot in the dark'.
What your computer is doing for the "3 to 4 hours" after it kicks off, is
executing your query. Your computer my be grossly underpowered with
inadequate memory for a "database has grown quite large" -when you are doing
operations that effect large amounts of data. It is probably quite ok for
relatively simple queries with small resultsets.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
[quoted text, click to view] "OdieTurbo" <todd.quigley@gmail.com> wrote in message
news:1158946519.598412.94480@m7g2000cwm.googlegroups.com...
> Arnie Rowland wrote:
>> Since you are using SQL Server version 7 on your laptop, I assume that
>> your
>> laptop is also quite 'dated'. If that is true, one of the best ways to
>> improve performance is to increase memory -or better yet, obtain a much
>> newer laptop.
>>
>> Half hearted joking aside, I recommend that you consider upgrading the
>> SQL
>> Server version -which probably would mean a hardware upgrade as well.
>> Perhaps this is the justification to support your request for a new
>> laptop.
>>
>> Without more details, it is going to be very difficult to offer you any
>> concrete advice.
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>
> Well, I am using the "Free" version Microsft gives out SQL Server
> Desktop. My machine is an IBM R51 with a Pentium M 1.7GHz and 1.25 GB
> of 1.69GHz RAM that cost a little over $2,000. So the hardware shoule
> be good.
>
> The main problem I see is that whenever I go to truncate a table, the
> processor and hard drive kick off and it does "something" for about 3
> to 4 hours. Then it will finally run my query.
>
