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 is the default port for SQL Server over a firewall?
Explain query editor regions
What is normalization 1nf 2nf 3nf?
Do you know what is lock escalation?
What happens if you delete a table that is used by a view?
What are the requirements for sql server 2016?
on line cluster can we make if yes tell me the procedure
how to control the amount of free space in your index pages? : Sql server database administration
What are the differences between substr and charindex in sql server.
Can you explain different types of joins?
explain different types of joins? : Sql server database administration
What it means to be triggered?
what is database replication? : Sql server database administration
Can we use trigger new in before insert?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
