Answer Posted / 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 |
Post New Answer View All Answers
How to check if stored procedure is running in sql server?
Name few of the dcl commands in sql?
What is temporal table?
What is RMS migrations?
How to implement service broker?
Are semicolons required at the end of sql statements in sql server 2005?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
What is nonclustered index with included columns ?
Explain the properties of subqueries in sql server?
What are the main differences between #temp tables and @table variables and which one is preferred?
Is mysql the same as sql server?
Explain what are the database objects? : SQL Server Architecture
How to modify existing triggers using "alter trigger"?
What is meant by dirty read?
What are a scheduled jobs or what is a scheduled tasks?