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.

List all types of constraints in sql server?

0 Answers  

---

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

1 Answers   HP,

---

Explain datetime2 data type in sal server 2008?

0 Answers  

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

0 Answers  

---

Explain some DBCC commands?

6 Answers  

---

---

what are the types of indexes? : Sql server database administration

0 Answers  

---

How display code or Text of Stored Procedure using Sql query in Sql Server ?

0 Answers   Wipro,

---

How to modify an existing stored procedure in ms sql server?

0 Answers  

---

What is enhanced database mirroring in sql server 2008?

0 Answers  

---

Explain the first normal form(1nf)?

0 Answers  

---

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

0 Answers  

---

Explain important index characteristics?

0 Answers  

---