Ok, I have created trace files, saved them as sql scripts, that they look
like that:

SELECT "PJID" ,"EMPLID" ,"PROJID" ,"CATEGORYID" ,"QTY" ,"SALESPRICE"
,"TRANSDATE" ,"PMAUNITS" ,"PMARATECODE" FROM "dbo"."PROJJOURNALTRANS" WHERE
("EMPLID" = 'SYLAN' )

go

declare @P1 int

set @P1=-1

declare @P2 int

set @P2=0

declare @P3 int

set @P3=20496

declare @P4 int

set @P4=8193

declare @P5 int

set @P5=0

exec sp_cursorprepexec @P1 output, @P2 output, N'@P1 varchar(1000),@P2
varchar(1000),@P3 varchar(1000),@P4 varchar(1000)', N'SELECT
A.JOURNALNUM,A.LINENUM,A.ACCOUNTTYPE,A.ACCOUNTNUM, A.TXT,A.AMOUNTCURDEBIT,A.C
URRENCYCODE,A.EXCHRATE,A.TAXGROUP,A.QTY,A.DIMENSIO N,A.DIMENSION2_,A.DIMENSIO
N3_,A.DIMENSION4_,A.DIMENSION5_,A.PRICE,A.SETTLEVO UCHER,A.POSTINGPROFILE,A.V
OUCHER,A.AMOUNTCURCREDIT,A.PAYMENTSTATUS,A.CASHDIS CAMOUNT,A.VENDTRANSID,A.CU
STTRANSID,A.REMAINAMOUNT,A.TAXCODE,A.OFFSETACCOUNT ,A.BANKDEPOSITVOUCHER,A.PA
YMREFERENCE,A.BANKDEPOSITNUM,A.PAYMSPEC,A.PAYMMODE ,A.OFFSETACCOUNTTYPE,A.BA



now how I know what to do and where? How can I tell what improvements and
where I can do?

PS I am not a programmer, I am a DBA

thanks