How can I shrink my TempDB Databse?

I have a problem with my TEMPDB Database.It gets extra size through
importing data into one of my databases in same server.
How can I shrink my TempDB Databse?

Thanks

.

Relevant Pages

  • Re: Moving tempdb
    ... there are two databases on the server that are being used. ... I also have another server running a database about 16GB in size. ... I'm planning on moving our tempdb to it's own LUN but I'm not sure what ...
    (microsoft.public.sqlserver.setup)
  • Re: Tempdb after restart
    ... If SQL has to auto-grow tempdb there are severe ... performance penalties. ... Microsoft SQL Server MVP ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Performance differences local vs. tempdb table
    ... As for the server my client works on (the big long ... process) his user database and tempdb are on two ... different drives. ... >> DECLARE @I INT ...
    (microsoft.public.sqlserver.server)
  • Re: tempdb is skipped. You cannot run a query that requires tempdb
    ... you must be using sqldatareader which utilizes forwardonly, readonly cursor ... and sqlserver likes to use tempdb for its worktable. ... > Has anyone seen the SQL Server error: ... > We're running a .Net web application with a SQL Server ...
    (microsoft.public.sqlserver.programming)
  • Re: ASPX pages failing when SQL Server busy
    ... TempDb is used quite a bit as a "scratchpad" to hold temporary ... Is the database segmented so it's not putting TempDb on the same ... I would't run the web server on the same machine as ... The sproc contains no explicit transactions or temp ...
    (microsoft.public.sqlserver.programming)