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 convert binary strings into integers in ms sql server?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
How to execute stored procedure and set temp table in sql server?
What happens if strings are casted into wrong code pages in ms sql server?
What is abstracting periodical?
what are the different types of SSRS reports?
How to enter date and time literals in ms sql server?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
Can a database be shrunk with users active?
How do I port a number to sql server?
How do I find the transaction log size in sql server?
What are cursors stored procedures and triggers?
How to attach adventureworkslt physical files to the server?
Do I need a report server to run reports in my application?
How to create a login account in ms sql server to access the database engine using "create login" statements?