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 |
How global temporary tables are represented and its scope?
Diffrences between sql server 2000 vs 2008
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What is precedence constraint?
What is data compression?
What is autocommit mode in sql server?
Is the log file is a part of file group?
What is the security model used in sql server 2005?
What is a filestream?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
Can two tables share a primary key?
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)