Interested to Buy Any Domain ? << Click Here >> for more details...
what is maximum size of temp db?
- 4 Answers
- 11621 Views
- iSoft, I also Faced
- E-Mail Answers
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 |
How can sql server instances be hidden?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
How to insert multiple rows with a subquery?
What is a print index?
How do I debug a stored procedure in sql server?
How adventureworkslt tables are related?
What do you need to connect php to sql server?
What are scalar functions in sql?
Questions on identity?
What is the difference between a fill factor of 100 and 0?
What happens if the update subquery returns no rows in ms sql server?
How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)
-
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)
