Explain temdb please

I understand that tempdb is a "temporary database", but in the real world,
can someone explain:
1)In the real world, when would I use tempdb?
2)Is it imporant that I understand tempdb? - Or is it rarely used?labsRcool@.community.nospan wrote:
> I understand that tempdb is a "temporary database", but in the real world
,
> can someone explain:
> 1)In the real world, when would I use tempdb?
> 2)Is it imporant that I understand tempdb? - Or is it rarely used?
You typically don't "use" tempdb explicitly, unless you are creating
temp tables. When you execute a large query that involves extensive
sorting, grouping, etc, SQL has to store that data somewhere as it's
being manipulated, that's where TEMPDB is used.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thanks so much!
"Tracy McKibben" wrote:

> labsRcool@.community.nospan wrote:
> You typically don't "use" tempdb explicitly, unless you are creating
> temp tables. When you execute a large query that involves extensive
> sorting, grouping, etc, SQL has to store that data somewhere as it's
> being manipulated, that's where TEMPDB is used.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||Hi
Along with Tracey's reply you may want to read what tempdb is used for in
books online see http://msdn2.microsoft.com/en-us/library/ms190768.aspx, the
system may make use of tempdb without you necessarily knowing, and therefore
sizing and the location of tempdb on heavily used system can be very
important http://msdn2.microsoft.com/en-us/library/ms175527.aspx this is eve
n
more important for SQL 2005 where row level versioning can use it, or if you
use notification services use will be made of tempdb
http://msdn2.microsoft.com/en-us/library/ms345368.aspx Overuse of tempdb by
your application may result in contention.
John
"labsRcool@.community.nospan" wrote:

> I understand that tempdb is a "temporary database", but in the real world
,
> can someone explain:
> 1)In the real world, when would I use tempdb?
> 2)Is it imporant that I understand tempdb? - Or is it rarely used?|||Thanks!
I now have a better understanding regarding this.
Those links are very helpful, thanks for your time!
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Along with Tracey's reply you may want to read what tempdb is used for in
> books online see http://msdn2.microsoft.com/en-us/library/ms190768.aspx, t
he
> system may make use of tempdb without you necessarily knowing, and therefo
re
> sizing and the location of tempdb on heavily used system can be very
> important http://msdn2.microsoft.com/en-us/library/ms175527.aspx this is e
ven
> more important for SQL 2005 where row level versioning can use it, or if y
ou
> use notification services use will be made of tempdb
> http://msdn2.microsoft.com/en-us/library/ms345368.aspx Overuse of tempdb b
y
> your application may result in contention.
> John
> "labsRcool@.community.nospan" wrote:
>