Which tcl commands are available on the sql server?

0 Answers  

---

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  

---

When do you think a developer should use sql server-based cursors?

0 Answers  

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

Where can you find the error log information? : sql server database administration

0 Answers  

---

How to assign null values to variables or columns?

0 Answers  

---

Can a table have 2 foreign keys?

0 Answers  

---

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

0 Answers  

---

You want to implement the many-to-many relationship while designing tables. How would you do it?

0 Answers  

---

What are different replication agents and what's their purpose? : sql server replication

0 Answers  

---

What is hot add cpu in sql server 2008?

0 Answers  

---

can you any body tell me which service pack is installed in the sql server?

3 Answers  

---