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
How to connect to SQL Azure Database by using sqlcmd?
Does order by actually change the order of the data in the tables or does it just change the output?
When do you think a developer should use sql server-based cursors?
How can you find out which stored procedures are recompiling?
Define Business Edition in SQL Azure?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
Detail about the hardware which is supported by SQL server?
Explain the xml support sql server extends?
What is a not null constraint?
Explain sub-query?
Can you get second highest salary from the table?
Define ACID properties in a Database?
Do you know what is user defined datatypes and when you should go for them?
on line cluster can we make if yes tell me the procedure