[dba-SQLServer] Temp db

Arthur Fuller fuller.artful at gmail.com
Thu Jul 26 22:18:38 CDT 2007


Quite right, Billy. I meant to say a temp table. Sorry for any confusion
there.

On 7/26/07, Billy Pang <tuxedoman888 at gmail.com> wrote:
>
> tempdb is created when sql server service starts (old one is dropped)
> tempdb is copied from the model db
>
>
> http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx
>
>
> On 7/26/07, jwcolby <jwcolby at colbyconsulting.com> wrote:
> >
> > Under what condition is a tempdb created?  How can I predict the size?
> >
> > I am looking at using a hardware ram disk to store the tempdb but I
> don't
> > want to get into this only to find out that the tempdb is larger than
> the
> > available ram disk (4 or possibly 8 gbytes max).
> >
> > John W. Colby
> > Colby Consulting
> > www.ColbyConsulting.com
> >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
> >
>
>
> --
> Billy Pang
> http://dbnotes.blogspot.com/
> "Once the game is over, the King and the pawn go back in the same box." -
> Italian proverb
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>



More information about the dba-SQLServer mailing list