hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  

---

What is the use of Port no?

1 Answers   Wipro,

---

Do you know spatial data types - geometry and geography in sql server 2008?

0 Answers  

---

Where the sql logs gets stored? : sql server database administration

0 Answers  

---

How to select all columns of all rows from a table with a select statement in ms sql server?

0 Answers  

---

---

How to create new table with "create table" statements?

0 Answers  

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

What is the difference between indexing and hashing?

0 Answers  

---

Differentiate between truncate vs delete in mssql?

0 Answers  

---

What is local temp table?

0 Answers  

---

What's the maximum size of a row?

4 Answers   IBM,

---

Why do we use non clustered index?

0 Answers  

---