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 we have to check in database testing?

582


What is field in algebra?

624


between cast and convert which function would you prefer and why?

532


what are cursors? : Sql server database administration

513


What do you understand by sql server agent?

531






Do you know how to implement service broker?

533


Explain what stored procedure sp_replcounters is used for? : sql server replication

997


How do I find the sql server version?

518


You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

545


what method you can use to reduce the overhead of Reporting Services data sources?

149


What are system databases into sql server (2005/2008)?

580


What are the new features in SQL Server 2005 when compared to SQL Server 2000?

620


what is the system function to get the current user's user id? : Sql server database administration

548


How to fine-tune reports?

151


Write SQL queries on Self Join and Inner Join.

606