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
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What are the events recorded in a transaction log?
What is the use of builtinadministrators group in sql server? : sql server security
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
What guidelines should be followed to help minimize deadlocks?
In what sequence sql statement is processed?
Explain where clause?
How do I run a trace in sql server?
What are the reporting services components?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
What is the main purpose of having conversation group?
How and why use sql server?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What to perform pattern match with the like operator?