what is maximum size of temp db?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by replication in sql server? Mention the different types of replication in sql server.

726


What do you mean by subquery?

787


What is transaction server distributed transaction?

756


Explain subquery and state its properties?

749


what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

748


Differentiate between ms sql server reporting services vs crystal reports?

698


Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

773


Where views are stored in sql server?

759


What is named query? : sql server analysis services, ssas

730


What is a schema in ms sql server 2005?

762


What is normalization process?

873


How to fetch the next row from a cursor with a "fetch" statement?

834


What is difference between line feed ( ) and carriage return ( )?

701


on line cluster can we make if yes tell me the procedure

1774


What do you mean by normalisation?

714