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 |
what is the difference between delete,drop and truncate
what is denormalization and when would you go for it? : Sql server database administration
How to delete duplicate records based on single column from a table?
0 Answers Petranics Solutions,
Explain isolation levels that sql server supports?
Selet all the data from table where last name is n of employee
what is the difference between table and view
How you can change the database name in SQL SERVER?
Why use update_statistics command in sql server?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
Where sql server user names and passwords are stored in sql server? : sql server database administration
How do you troubleshoot errors in a SQL Server Agent Job?
What are the tables in sql?
Oracle (3259)
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)