Re: Which one to use ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Uri Dimant (urid_at_iscar.co.il)
Date: 06/23/04 

Date: Wed, 23 Jun 2004 09:23:56 +0200

Thanks

"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:%23ZOdo8HWEHA.4092@TK2MSFTNGP11.phx.gbl...
> I believe we have one in Toronto:
>
> http://www.tssug.org/
>
> --
> Tom
>
> ---------------------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
>
> "Uri Dimant" <urid@iscar.co.il> wrote in message
> news:uj4yr3EWEHA.2716@tk2msftngp13.phx.gbl...
> Hi,Tom
> How are your doing?
> I know you are from Toronto , can you tell me please ,is there SQL Server
> User Group in Ontario?
> Thank you.
>
>
> "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
> news:%23IKF2wEWEHA.3016@tk2msftngp13.phx.gbl...
> > Both are equivalent. However, you should avoid SELECT *. Specifying
the
> > columns in the SELECT list reduces network traffic. In some cases, it
can
> > speed up the query itself, due to index covering.
> >
> > --
> > Tom
> >
> > ----------------------------------------------------
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > SQL Server MVP
> > Columnist, SQL Server Professional
> > Toronto, ON Canada
> > www.pinnaclepublishing.com/sql
> > .
> > "mkarja" <mmmc_reptail@hotmail.com> wrote in message
> > news:75a5303b.0406220309.22c24bdf@posting.google.com...
> > Hi,
> >
> > I have a query that I send to sql server 2000 from C++ code
> > thru ADO.
> > I'm just wondering which way would be better / faster.
> > Here's the two queries :
> >
> > SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
> > SELECT * FROM Table
> > WHERE Table.column1 = 'first'
> > ---------------------
> > SELECT * FROM Table
> > WHERE Table.column1 = 'first'
> > WITH (NOLOCK)
> >
> > These are of course just a basic sample queries.
> > Is there a difference in speed, and which one would be
> > better in my case, when I just execute one pretty basic query
> > at a time. There's no complex procedures or anything, just a
> > simple query.
> > The result sets that's returned from the server can be just
> > few lines or thousands of lines.
> >
> > Any help is appreciated, thanks.
> >
> > ----
> > mkarja
> >
>
>

Relevant Pages