1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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.

Question Posted / hari


my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) su..

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

Post New Answer

More SQL Server Interview Questions

What is intellisense?

0 Answers  

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz

6 Answers  

Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60

3 Answers   IT Decisions,

How to enter binary string literals in ms sql server?

0 Answers  

What is a full text index?

0 Answers  




Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,

What is the default server name for sql server?

0 Answers  

What is resource governor?

0 Answers  

How do we return a record set from a Stored Procedure in SQl server 2000?

3 Answers  

Explain the difference between primary keys and foreign keys?

0 Answers  

what purpose does the model database serve? : Sql server database administration

0 Answers  

How do you rebuild an identity column?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories