Interested to Buy Any Domain ? << Click Here >> for more details...
Which is best Subquery (or) joins in sql server? explain why
- 2 Answers
- 11307 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 are the new data types are introduced in sql 2000?
Differentiate between truncate vs delete in mssql?
What is the current limitation of the size of SQL Azure DB?
How does recursive cte works in sql server?
What do you understand by mirroring?
Do you know what are the differences between lost updates and uncommitted dependencies?
What is the difference between a function and a trigger?
What is cursor in ms sql server?
List out a number of the wants to setup a SQL Server failover cluster?
Why would you call update statistics?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
Tell me what is difference between clustered and non clustered index?
What is an index in sql?
What is the difference between SQL notification and SQL invalidation?
What is logon trigger?
