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
What Are the Main Features of SQL Azure?
where can you add custom error messages to sql server? : Sql server administration
Which rendering formats are affected by the pagesize properties?
What is implicit mode in sql server?
What different steps will a sql server developer take to secure sql server?
Can we insert data into view sql server?
How much space does sql server 2016 take?
What is the difference between a function and a stored procedure?
How to update muliple row in single query?
What is the difference between index seek vs. Index scan?
How do I edit a procedure in sql server?
What is the difference between varchar and varchar(max) datatypes?
what is an index? : Sql server database administration
What is the difference between a primary key and a unique key? Are they the same?
What is a not null constraint?
