MS SQL Server - Temp DB use and query Evaluvation Question

Author

Temp DB use and query Evaluvation Question

bluefish

2006-03-08, 8:23 pm

Dear All,

Does SQL server store the intermediate results set in the tempdb? One of the
team members has dropped the indexes for our one large table. I was running a
query that has multiple joins (including this table) , and this caused tempdb
to fill up.
According to this article by Microsoft,
http://msdn2.microsoft.com/en-us/library/ms190768.aspx, I'm under impression
that table scan has stored a large set of intermediate data in tempdb, which
caused it to fill up.

My team members seem to argue that temp db is only used when we use temp
tables.

Secondly, does sql server evaluate the join first, or where clause first?
(Or it depends on each query?)

Thank you much for your help in advance.

Russell Fields

2006-03-08, 8:23 pm

bluefish,

Yes, tempdb is used for a number of things including the 'worktables' that
the optimizer needs to create in order to handle joins that cannot be
managed through some other method.

RLF
"bluefish" < bluefish@discussions
.microsoft.com> wrote in message
news:CA204C73-D0D3-49F7-BFDE- 3A470EEAD36F@microso
ft.com...
> Dear All,
>
> Does SQL server store the intermediate results set in the tempdb? One of
> the
> team members has dropped the indexes for our one large table. I was
> running a
> query that has multiple joins (including this table) , and this caused
> tempdb
> to fill up.
> According to this article by Microsoft,
> http://msdn2.microsoft.com/en-us/library/ms190768.aspx, I'm under
> impression
> that table scan has stored a large set of intermediate data in tempdb,
> which
> caused it to fill up.
>
> My team members seem to argue that temp db is only used when we use temp
> tables.
>
> Secondly, does sql server evaluate the join first, or where clause first?
> (Or it depends on each query?)
>
> Thank you much for your help in advance.
>

Sponsored Links