Explain about protocol layer present in SQL server?

0 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

Explain cross join or cartesian product in sql?

0 Answers  

---

What is 1nf normalization form?

0 Answers  

---

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

0 Answers  

---

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

0 Answers  

---

What is the difference between UNION and UNIONALL?

5 Answers   CarrizalSoft Technologies, CTS,

---

Where sql server user names and passwords are stored in sql server? : sql server database administration

0 Answers  

---

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

0 Answers  

---

What is referential integrity? What are the advantages of it?

4 Answers   Descon, Digital Domain,

---

How you can get a list of all the table constraints in a database? : Sql server administration

0 Answers  

---