what is maximum size of temp db?
Answers were Sorted based on User's Feedback
Answer / senthilkumar
The syntax is : sp_helpdb 'tempdb'
db_size of a tempdb is 8.50 MB in sqlserver 2005.
Is This Answer Correct ? | 10 Yes | 5 No |
Answer / inampudi anil chowdary
the above two answers are wrong....... the max size of tem
db by default is -1. the main usage of tempdb is.if u run
a query the data will store in tempdb from tempdb we can
get output..but max size is -1;
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / senthilkumar
Physical Properties of tempdb
The following table lists the initial configuration values of the tempdb data and log files. The sizes of these files may vary slightly for different editions of SQL Server.
File Logical name Physical name File growth
Primary data
tempdev
tempdb.mdf
Autogrow by 10 percent until the disk is full
Log
templog
templog.ldf
Autogrow by 10 percent to a maximum of 2 terabytes
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / anamika
How to know the size of any database:
Syntax:
sp_helpdb 'tempdb'
db_size of temp db 38.56 MB.
Is This Answer Correct ? | 6 Yes | 8 No |
What are the different types of join?
Tell me about joins in database system and explain each in detail.
0 Answers Axtria, ITC Indian Tobacco Company,
What are the grouping functions?
Explain how to use linked server?
Differentiate between mongodb vs. Sql server?
How to view the error log for any specific instance? : sql server database administration
can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?
What command is used to rename the database?
Where can you add custom error messages to sql server?
Tell me extended events in sql server 2008?
How to connect to a sql server using odbc_connect()?
What are the different types of cursor?