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.



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 inline table-value user-defined function?

0 Answers  


How will you collect the date from current date to last older 6 days date in sql server 2005

4 Answers  


What are triggers in ms sql server?

0 Answers  


About Indexed Views? with example? plz reply...

2 Answers  


What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

9 Answers   DELL, i Tech, Infosys, Siemens, TCS,






How do I start sql server agent automatically?

0 Answers  


What is the difference between function and stored procedure in sql server?

0 Answers  


What happens if null values are involved in bitwise operations?

0 Answers  


What is hot add cpu in sql server 2008?

0 Answers  


How would you Update the rows which are divisible by 10, given a set of numbers in column?

3 Answers  


How to create user defined functions with parameters?

0 Answers  


What are the different types of collation sensitivity?

0 Answers  


Categories