From: "Robert Comer" 

> Just realized the below didn't state the conclusion, i.e., tempdb grows
> exponentially when you're doing stuff...  therefore it shouldn't be
> installed somewhere that only has 1 GB free.   By default it gets
> installed wherever you install SQL Server, but you can move it if SQL
> Server is installed someplace small as in our case.

Yep, makes sense to me.

- Bob Comer



"Ellen K."  wrote in message
news:s12k0vsr466q6dpdu3ae48kcmsuhkqibjt{at}4ax.com...
> Just realized the below didn't state the conclusion, i.e., tempdb grows
> exponentially when you're doing stuff...  therefore it shouldn't be
> installed somewhere that only has 1 GB free.   By default it gets
> installed wherever you install SQL Server, but you can move it if SQL
> Server is installed someplace small as in our case.
>
> On Wed, 25 Dec 2002 11:22:13 -0800, Ellen K. 
> wrote in message :
>
> >tempdb is a system database (like master).   When you make changes to
> >your data, temporary 'inserted' and/or  'deleted' tables are created in
> >tempdb that are used a) in case you need to roll back and b) for your
> >triggers.   (And maybe the transactions log also uses them, I'm not sure
> >but am too lazy to look it up... Can you tell I'm a developer and not a
> >DBA?   >
> >On Wed, 25 Dec 2002 08:01:50 -0500, "Robert Comer"
> > wrote in message
:
> >
> >>So it was just a space problem.  I was wondering just what the problem
> >>was...
> >>
> >>- Bob Comer
> >>
> >>
> >>"Ellen K."  wrote in message
> >>news:0fni0vo62q9vq76ldii1elvgi04pm1e5jn{at}4ax.com...
> >>> If they hadn't partitioned the drive (or hadn't installed
SQL Server
on
> >>> the C partition) there would have been no problem... the
problem was
> >>> that the C partition is only 4 GB.   That ain't Microsoft's fault.
> >>>
> >>> On Sun, 22 Dec 2002 07:41:30 -0500, Mike '/m'
 wrote
in
> >>> message :
> >>>
> >>> >On Sat, 21 Dec 2002 22:20:28 -0800, Ellen K.
> >>> > wrote:
> >>> >
> >>> >>but idiiot #2, who set up SQL Server, obviously
doesn't know
> >>> >>anything about its internals,
> >>> >
> >>> >but... but... but... isn't Microsoft back office sooooo easy to
> >>> >install and run that you don't need high-powered
admins like linux
> >>> >does?
> >>> >
> >>> >isn't one of the reasons for using Microsoft server
software that you
> >>> >don't need to kow what you're doing, just install and run?
> >>> >
> >>> > /m
> >>>
> >>
>

--- BBBS/NT v4.01 Flag-4