how does a query work

25 May 2006 6:06 PM

Dan D.

Can anyone recommend a good book, article, whitepaper, etc. on how queries
work? For instance, whether it's good to put a large table before a small
table in a query, what the interaction is between an inner query (subquery)
and the outer query, the interaction of queries nested several layers deep,
does the order of the columns in the where clause matter, etc.

Thanks,

--
Dan D.

25 May 2006 6:13 PM

Jerry Spivey

Dan,

Start here:

http://www.sql-server-performance.com/articles_performance.asp

HTH

Jerry
Show quoteHide quote

"Dan D." <D***@discussions.microsoft.com> wrote in message
news:7AB28880-1F50-4340-A58D-A55F7CF5008A@microsoft.com...
> Can anyone recommend a good book, article, whitepaper, etc. on how queries
> work? For instance, whether it's good to put a large table before a small
> table in a query, what the interaction is between an inner query
> (subquery)
> and the outer query, the interaction of queries nested several layers
> deep,
> does the order of the columns in the where clause matter, etc.
>
> Thanks,
> --
> Dan D.

26 May 2006 1:32 PM

Dan D.

Thanks. That's quite a list. There looks like there are a lot of good
articles there.

--
Dan D.

Show quoteHide quote

"Jerry Spivey" wrote:

> Dan,
>
> Start here:
>
> http://www.sql-server-performance.com/articles_performance.asp
>
> HTH
>
> Jerry
> "Dan D." <D***@discussions.microsoft.com> wrote in message
> news:7AB28880-1F50-4340-A58D-A55F7CF5008A@microsoft.com...
> > Can anyone recommend a good book, article, whitepaper, etc. on how queries
> > work? For instance, whether it's good to put a large table before a small
> > table in a query, what the interaction is between an inner query
> > (subquery)
> > and the outer query, the interaction of queries nested several layers
> > deep,
> > does the order of the columns in the where clause matter, etc.
> >
> > Thanks,
> > --
> > Dan D.
>
>
>

25 May 2006 8:07 PM

David Browne

"Dan D." <D***@discussions.microsoft.com> wrote in message
news:7AB28880-1F50-4340-A58D-A55F7CF5008A@microsoft.com...
> Can anyone recommend a good book, article, whitepaper, etc. on how queries
> work? For instance, whether it's good to put a large table before a small
> table in a query, what the interaction is between an inner query
> (subquery)
> and the outer query, the interaction of queries nested several layers
> deep,
> does the order of the columns in the where clause matter, etc.
>

"Inside Microsoft SQL Server 2005 T-SQL Querying" explains the whole
process, along with a methodology for query tuning.

David

26 May 2006 1:31 PM

Dan D.

I've seen several poor reviews for that book. Do you like the book overall or
do you think that it just does a good job on what I'm asking about?

Thanks,

--
Dan D.

Show quoteHide quote

"David Browne" wrote:

>
> "Dan D." <D***@discussions.microsoft.com> wrote in message
> news:7AB28880-1F50-4340-A58D-A55F7CF5008A@microsoft.com...
> > Can anyone recommend a good book, article, whitepaper, etc. on how queries
> > work? For instance, whether it's good to put a large table before a small
> > table in a query, what the interaction is between an inner query
> > (subquery)
> > and the outer query, the interaction of queries nested several layers
> > deep,
> > does the order of the columns in the where clause matter, etc.
> >
>
> "Inside Microsoft SQL Server 2005 T-SQL Querying" explains the whole
> process, along with a methodology for query tuning.
>
> David
>
>
>

26 May 2006 1:50 PM

David Browne

"Dan D." <D***@discussions.microsoft.com> wrote in message
news:9C6ABE90-98E4-44DB-A638-F8CB7EA619A4@microsoft.com...
> I've seen several poor reviews for that book. Do you like the book overall
> or
> do you think that it just does a good job on what I'm asking about?
>

Understanding query processing and tuning takes up a good chunk of the book.
You have to realize that that volume is pretty focused. TSQL Programming is
a seperate volume, and the Storage Engine is a seperate volume.

David

31 May 2006 5:30 PM

Dan D.

The first three chapters are exactly what I was looking for. The rest of the
book looks good too.

Thanks,

--
Dan D.

Show quoteHide quote

"David Browne" wrote:

>
> "Dan D." <D***@discussions.microsoft.com> wrote in message
> news:9C6ABE90-98E4-44DB-A638-F8CB7EA619A4@microsoft.com...
> > I've seen several poor reviews for that book. Do you like the book overall
> > or
> > do you think that it just does a good job on what I'm asking about?
> >
>
> Understanding query processing and tuning takes up a good chunk of the book.
> You have to realize that that volume is pretty focused. TSQL Programming is
> a seperate volume, and the Storage Engine is a seperate volume.
>
> David
>
>
>

Thread options