Interested to Buy Any Domain ? << Click Here >> for more details...
Which is best Subquery (or) joins in sql server? explain why
- 2 Answers
- 11337 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
What is pivot and unpivot?
Tell me what is difference between clustered and non clustered index?
How to create a ddl trigger using "create trigger" statements?
Explain a join?
Explain the first normal form(1nf)?
What is triggers in ms sql server?
Tell me what do we need queues in sql service broker?
What are the types of table?
What is the full form of dql?
What is the use of sql profiler in sql server 2012?
Define union, union all, minus, intersect?
What is failover clustering overview?
Scalability, Availability, Integration with internet, etc.)?
What is the difference between functions and stored procedures?
What is tablesample?
