I think , I want both - could you give us some SAMPLEs -- full set of sample code please

(thanks for replying)

for store procedure

for raw SQL (as I saw some company using raw SQL in the ASP ,

but

when manager retrieving report, it slows down

when some users, routinely enter new data (some simple data, like payment retrieval, or

when lots of customer service dept users, check on data) all these sceneraio will SLOW down the system -- till to a point that it have to restart the computer, every 2 days

( I believe, they use Raw SQL , that partially account for such SLOWness)

--- i.e. , could you give us some sample on both (simple but full set of coding)

do you have some other idea (besides index tuning, that could make the system faster)

I did try to upgrades it SQL server v7 to SQL server 2000, but then

ooooops, I install as the SAME INSTANCE in SQL server 2000, then the system CRASH

and because of some strange reason , SQL server 2000, can't be uninstalled -- got some error)

-- beside the full code in both RAW / SP, could you suggest some other Performance Tuning too

-- the set up is one Dual CPU computer, using windows 2003 standard edition, running BOTH the ASP program and running the SQL server v7

MANY THANKS for guidance