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 sql server 2000 version number?
What is the recommended total size of your memory optimized tables?
What is factless fact table? : sql server analysis services, ssas
what is a check constraint?
How to make conditional sum in ssrs?
What is the difference between ddl and dml?
List out the differences between the clustered index and non-clustered index in sql server?
How to write a query with a full outer join in ms sql server?
What are the different subsets of sql?
Please explain what is “asynchronous” communication in sql server service broker?
What is delete query?
How to execute stored procedure and set temp table in sql server?
What is buffer cash in sql server?
Can we use max in where clause?
What is acid db?