Re: performance

From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 01/13/05 

Date: Thu, 13 Jan 2005 10:19:20 -0500

Ed wrote:
> hi all,
> I am trying to tune up the performance of some of the sql statements.
> I am under the impression if i can avoid the table scan and clustered
> index scan, that should be about 80% good, am i right?
> Thanks
> Ed

The only answer to such a non-specific question is to supply this url for
you to browse:
http://www.sql-server-performance.com/articles_performance.asp

Bob Barrows 

-- 
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Relevant Pages

  • performance
    ... I am trying to tune up the performance of some of the sql statements. ... I am under the impression if i can avoid the table scan and clustered ...
    (microsoft.public.sqlserver.programming)
  • Re: ADOX - Access table creation with nullable columns.
    ... I got the impression from your reply to me in the other thread that ... Andy wrote: ... with the Column object and hoped to enumerate through them to ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: 10 Important Dating Tips for Men
    ... first impression." ... Well, you will, if you date someone with anterograde amnesia. ... [The address listed is a spam trap. ... — Joss Whedon ...
    (talk.origins)
  • Re: Multiple Queries on same asp page..
    ... > and if these sql statements were stored procedures, ... Microsoft MVP - ASP/ASP.NET ... This email account is my spam trap so I don't check it very often. ...
    (microsoft.public.inetserver.asp.general)