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.

1 Answers  

---

How to find the list of fixed hard drive and free space on server?

0 Answers  

---

How many types of Joins in SQL Server 2005?

9 Answers   CarrizalSoft Technologies, HCL,

---

What action plan is preferred if sql server is not responding?

0 Answers  

---

How to drop existing views from a database in ms sql server?

0 Answers  

---

Diffrences between sql server 2000 vs 2005

2 Answers   Thomson Reuters,

---

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

1 Answers   United Healthcare,

---

Can two tables have the same primary key?

0 Answers  

---

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

0 Answers  

---

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

0 Answers   Value Labs,

---

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

0 Answers  

---

How to create an inline table-valued function?

0 Answers  

---