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

How use inner join in sql server?

623


How to create a view with data from multiple tables?

567


How to find the login name linked to a given user name?

540


Where are sql server usernames and passwords stored in the sql server?

622


Why use cursor in sql server?

560






Tell me what is log shipping?

584


What will be query used to get the list of triggers in a database?

555


What is resource db in sql server?

605


Do you know how to store and query spatial data?

615


While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

631


What is indexing and its types?

544


Which are ddl commands?

551


What is difference between group by and having?

568


What are the different types of backups that exist?

691


What is the difference between stored procedure and functions?

606