"Tracy McKibben" wrote:

> 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
>

"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?

"John Bell" wrote:

> 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 even
> 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?