what are batch in sql server?

2 Answers   Satyam,

---

how to improve the speed of SQL database server and how to avoid dead lock?

1 Answers   TCS,

---

Explain the phases a transaction has to undergo?

0 Answers  

---

find 2nd highest salary of person using cursor concept?

6 Answers   HCL,

---

What do you mean by acid?

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  

---

How to create a login account in ms sql server to access the database engine using "create login" statements?

0 Answers  

---

What is transaction server auto commit?

0 Answers  

---

What is Dedicated Administrator Connection in sql server 2005?

2 Answers  

---

What are scalar functions in sql?

0 Answers  

---

What is scd (slowly changing dimension)? : sql server analysis services, ssas

0 Answers  

---

How can you check the version of sql server?

0 Answers  

---