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 is the minimum recommended amount of ram for sql server 2012 enterprise?

712


What are the steps you must follow to hide sql server instances?

740


do you know how to configure db2 side of the application? : Sql server database administration

809


How to transfer a table from one schema to another?

766


What does the automatic recovery do?

807


Can we add an identity column to decimal datatype?

779


What is difference between oltp and olap?

815


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2284


What is the difference between DATETIME2 and DATETIME?

830


What are views in ms sql server?

821


Explain query editor regions

820


How do I view views in sql server?

727


what is new philosophy for database devises for sql server 7.0? : Sql server database administration

716


Can we call future method from trigger?

706


Why I can not enter 0.001 second in date and time literals in ms sql server?

782