What are “lock” hints?

0 Answers  

---

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

---

Advantages and disadvantages of stored procedures.

2 Answers   HCL,

---

How to invoke a trigger on demand?

0 Answers  

---

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 Answers  

---

---

In which situation you use Self joins?

1 Answers   CarrizalSoft Technologies, HP, TCS,

---

Explain log shipping?

0 Answers  

---

How to check status of stored procedure in 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  

---

What are the different types of normalization?

0 Answers  

---

How to get a list of columns in a view using "sys.columns" in ms sql server?

0 Answers  

---

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 Answers   Accenture, Merrill Lynch, Wipro,

---