Answer / rajeevrohilla

In normal situation join are best since there is no
subquery for each record for the other table. but in some
situations Subquery are best. for example- when the
subquery results one or fewer (3 or 4 records) that it will
work faster since it also saves the joining time(if there
are more than 1 joining fields then joining takes lots of
time). Subquries also perform better when tables have less
amount of data.

Answer / parmanand

Joins are good, Sub queries are substantially faster than
cursor in most cases, however shower than other options that
might be available in SQL Server.

What is difference between getdate and sysdatetime in sql server 2008?

0 Answers  

---

When would you prefer to have a minimum number of indexes?

0 Answers  

---

Describe and explain about SQL native client?

0 Answers  

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

---

What is database black box testing?

0 Answers  

---

What is the difference between clustered and non-clustered indexes in ms sql server?

0 Answers  

---

In which year relase the 7.0& 2000 & 2005?

1 Answers  

---

How do you size a resultset?

0 Answers  

---

What is the boxing and unboxing concept in .net?

0 Answers  

---

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 Answers  

---

how to retrive only second row from table in sql server 2000?

15 Answers   Cognizant, CTS,

---

What is simple indexing method?

0 Answers  

---