which table keeps the locking information? : Sql server administration

0 Answers  

---

Why is normalisation important?

0 Answers  

---

What does truncate do?

0 Answers  

---

List some case manipulation functions in sql?

0 Answers  

---

What are the advantages of using sql server over ms access or why should one use sql instead of ms access

2 Answers   CMS, Impetus,

---

---

Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 Answers   TCS,

---

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

0 Answers  

---

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers  

---

Define left outer join in sql server joins?

0 Answers  

---

What command do we use to rename a database?

0 Answers  

---

How will you find out if there are expensive SQL statements running or not?

0 Answers   Atos Origin,

---

What are cursors? Name four types of cursors and when each one would be applied?

3 Answers   Adea Solutions,

---