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
What is the difference between an index and a unique index?
What is the use of tempdb? What values does it hold?
What is page in sql server?
Explain the difference between primary keys and foreign keys?
Can you please explain the difference between function and stored procedure?
What is sql server programming?
Explain the steps to create and execute a user-defined function in the sql server?
How to get the number of affected rows?
How to define the name and server for a new dsn?
What are the new features in sql server 2016?
Do you know exporting and importing utility?
Explain the different types of joins?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What happens when unicode strings concatenate with non-unicode strings?
1 01 101 01010