What is a natural primary key?

0 Answers  

---

CTE(common table expression)

1 Answers   Thomson Reuters,

---

what are different types of backups available in sql server? : Sql server database administration

0 Answers  

---

What are page splits? : SQL Server Architecture

0 Answers  

---

What is constraints and its types?

0 Answers  

---

What are different backups available in sql server?

0 Answers  

---

how to get max salary with employee number by using one select query and max function ??

3 Answers   Genpact,

---

What is similarity and difference between truncate and delete in sql?

0 Answers  

---

How can sql server instances be hidden? : sql server security

0 Answers  

---

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,

---

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 are the five major components of a dbms?

0 Answers  

---