Interested to Buy Any Domain ? << Click Here >> for more details...
Which is best Subquery (or) joins in sql server? explain why
- 2 Answers
- 11356 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
Write SQL queries on Self Join and Inner Join.
Can you always create a cache of a report?
How you can minimize the deadlock situation?
How to create a trigger for insert only?
What is NOT NULL Constraint in sql server 2012?
What are the different sql server versions?
Explain timestamp datatype?
Can we linked SharePoint to a SQL database?
What is the process of indexing?
How to create a dynamic cursor with the dynamic option?
What is transactional replication?
What are the difference between primary key and unique key? : sql server database administration
What do you mean by 'normalization'?
Can I use sql azure as a backup with log shipping or database mirroring?
What do you understand by check constraint in sql server?
