• 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