Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

what is maximum size of temp db?

Question Posted / guest

Answers were Sorted based on User's Feedback



what is maximum size of temp db?..

Answer / senthilkumar

The syntax is : sp_helpdb 'tempdb'

db_size of a tempdb is 8.50 MB in sqlserver 2005.

Is This Answer Correct ?    10 Yes 5 No

what is maximum size of temp db?..

Answer / inampudi anil chowdary

the above two answers are wrong....... the max size of tem
db by default is -1. the main usage of tempdb is.if u run
a query the data will store in tempdb from tempdb we can
get output..but max size is -1;

Is This Answer Correct ?    6 Yes 2 No

what is maximum size of temp db?..

Answer / 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

what is maximum size of temp db?..

Answer / anamika

How to know the size of any database:
Syntax:
sp_helpdb 'tempdb'

db_size of temp db 38.56 MB.

Is This Answer Correct ?    6 Yes 8 No

Post New Answer

More SQL Server Interview Questions

How to get a list of columns using the "sys.columns" view in ms sql server?

0 Answers  

What is similarity and difference between truncate and delete in sql?

0 Answers  

How would you use user_constraints table in DB?

0 Answers   Wipro,

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

0 Answers  

What is Index ? Explain its Types?

2 Answers   ADP,

What do you understand by coalesce in sql server?

0 Answers  

Can two different columns be merged into single column? Show practically?

0 Answers   QuestPond,

How do I find query history in sql server?

0 Answers  

How to create a simple table to test triggers in ms sql server?

0 Answers  

Why do you want to join software field as you have done your BE in Electronics?

0 Answers   Cap Gemini, HCL,

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 Answers  

What are the kinds of subquery?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories