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.

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How to connect to SQL Azure Database by using sqlcmd?

110


Does order by actually change the order of the data in the tables or does it just change the output?

686


When do you think a developer should use sql server-based cursors?

524


How can you find out which stored procedures are recompiling?

516


Define Business Edition in SQL Azure?

88






do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

487


What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

602


Detail about the hardware which is supported by SQL server?

591


Explain the xml support sql server extends?

625


What is a not null constraint?

600


Explain sub-query?

571


Can you get second highest salary from the table?

556


Define ACID properties in a Database?

630


Do you know what is user defined datatypes and when you should go for them?

506


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

1517