Interested to Buy Any Domain ? << Click Here >> for more details...
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
Why should you use or avoid select * statements?
What are extended events in sql server?
What are page splits? : SQL Server Architecture
What are the 10 characteristics of data quality?
How to connect ms access to sql servers through odbc?
How to copy the tables, schema and views from one sql server to another?
How to create a simple stored procedure in ms sql server?
How can we delete Duplicate row in table?
What are differences in between sql server 2012 and sql server 2016?
Explain how would you store your query in an SSRS report or a Database server?
What is bit data type? What's the information that can be stored inside a bit column?
How does clustered and non clustered index work?
How do I find the sql server instance name?
What are the types of sql server?
Explain identity in sql server?
