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 |
Why do we use functions?
Explain what are various ways to enhance the ssrs report?
What are unicode character string data types in ms sql server?
Explain the different index configurations a table can have?
What is difference between clustered and non clustered index?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
List the various tools available for performance tuning?
Wht is the difference between stored procedure and trigger
What is the exact numeric data type in sql?
What are different types of Keys? Please explain all the keys with a suitable example.
Explain how to send email from sql database?
How can we write or define DDL statements in Sql server and DML statements?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)