my problem is tempdb

tempdb(dbname) 77752.95 MB(db size) 25345.03 MB
(unallocated size)

suppose i increased temp db size 10 gb . after increase the
temp db showing

87 gb (dbsize) 25346.03MB(unallocated
size)--unallocated size is showing same .please clarify.



my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) su..

Answer / guest

when you increase the size, make sure that there is enough
space on the drive, if there is no enough space on
drive,then it does not reflect.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to turn off warning messages during php execution?

0 Answers  


What are basics of policy management?

0 Answers  


What are sparse columns?

0 Answers  


Explain what is meant by replication of database?

0 Answers   Cap Gemini,


What is serializable?

0 Answers  






what are user defined datatypes? : Sql server database administration

0 Answers  


how to improve the speed of SQL database server and how to avoid dead lock?

1 Answers   TCS,


What do I need to start working with sql studio? : sql server management studio

0 Answers  


Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  


How many types of indexes are there in SQL Server?

6 Answers   CarrizalSoft Technologies, United Healthcare,


can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?

1 Answers  


Tell me about the approaches which you used to counter the DI problems.

0 Answers   EXL,


Categories