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 / 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 |
Can another user execute your local temporary stored procedures?
Why we need sql server?
what are constraints? Explain different types of constraints? : Sql server database administration
Explain the working of sql privileges?
What is RAID and what are different types of RAID configurations?
What is use of except clause? How it differs from not in clause?
wht is normalization?can u explain me in detail?
How to attach adventureworkslt physical files to the server?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
How sql server executes a statement with nested subqueries?
What are the 10 characteristics of data quality?
List the different types of collation sensitivities in sql server?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)