Re: [Speeding Up SQL Server]

2001-06-08 Thread Michael Smith
y ensure code is efficient as poss > > -Original Message- > From: Alex [mailto:[EMAIL PROTECTED]] > Sent: 08 June 2001 15:38 > To: CF-Talk > Subject: Re: [Speeding Up SQL Server] > > Are you sure its the machine? Or is it the network, or the code, or the DB > design > > &qu

RE: [Speeding Up SQL Server]

2001-06-08 Thread Andy Ewings
speed could well be down to the code you use to interogate it. Use SP's where possible. Stay away from Cursors, and generally ensure code is efficient as poss -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: 08 June 2001 15:38 To: CF-Talk Subject: Re: [Speeding Up SQL Ser

Re: [Speeding Up SQL Server]

2001-06-08 Thread Alex
Are you sure its the machine? Or is it the network, or the code, or the DB design "Ben Densmore" <[EMAIL PROTECTED]> wrote: I was wondering if someone can give me some ideas of the best way to speed up SQL Server? Right now our server that runs SQL Server is not the fastest of machines, actually

RE: Speeding Up SQL Server

2001-06-08 Thread Dan G. Switzer, II
e sure you've got all your indexes applied, run trace routes on your queries to look for points of optimization, etc... -Dan > -Original Message- > From: Ben Densmore [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 08, 2001 9:59 AM > To: CF-Talk > Subject: Speeding Up SQ

Speeding Up SQL Server

2001-06-08 Thread Ben Densmore
I was wondering if someone can give me some ideas of the best way to speed up SQL Server? Right now our server that runs SQL Server is not the fastest of machines, actually it's quite slow. it's a P 200 with 128 megs of ram. I've been bugging the company to buy a new server which they did but n