Thank you tom.lemmer, GilaMonster, Michael Vessey for the response...
Correction on the specs i provided last time (just receive the full info from the client)
*Quad-Core Xeon E5420 (2x6 MB cache) 2.50 Ghz
*4X4 GB DDR2 667Mhz Memory
*Windows 2003 Enterprise Edition-32bit R2
*SQL Server 2005 Standard Edition
@tom.lemmer, i've check the system properties of the server and found that 16GB were found. In the boot.ini, PAE is not enable (how will i know if they are using Hot Add Memory or DEP is enable) but the system found it 16GB. Ill take a study on the re-indexing maintenance job (i haven't tried it and i check the server if they have a plan guide but nothing is there).
this is the table structure for the said module
CREATE TABLE [dbo].[DRSummTemp](
[ID] [int] IDENTITY(1,1) NOT NULL,
[DRID] [int] NULL,
[StyleNo] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Quantity] [int] NULL,
[UnitPrice] [money] NULL,
[Amount] [money] NULL,
[Cost] [money] NULL,
CONSTRAINT [PK_DRSummTemp] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY],
CONSTRAINT [IX_DRSummTemp] UNIQUE NONCLUSTERED
(
[DRID] ASC,
[StyleNo] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
@gilamonster, ill study that article, thanks
@michael-2 Vessey, this is the stored procedure for retrieval
ALTER PROCEDURE [dbo].[Get_DRTotalQuantityAndCost_SP]
-- Add the parameters for the stored procedure here
@CustomerNumber bigint,@DateFrom DateTime = Null, @DateTo DateTime = Null
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
select sum(DRSummTemp.Quantity) As TOTAL_QUANTITY,sum((DRSummTemp.Quantity*DRSummTemp.cost)) as TOTAL_COST
from DRSummTemp where DRSummTemp.drid in
(select ID from DRTemp where DRDATE between @DateFrom and @DateTo and CUSTNO = @CustomerNumber);
END