Which is best Subquery (or) joins in sql server? explain why
- 2 Answers
- 10670 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
Explain how you can configure a running aggregate in SSRS?
Do you know what are the steps to process a single select statement?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
What is 'write-ahead log' in sql server 2000 ?
What is transaction server isolation?
Is sql different from sql server?
How to replace given values with null using nullif()?
What is SQL Azure Data sync?
What are the different Topologies in which Replication can be configured?
Indexes are updated automatically is the full-text index also updated automatically?
How does clustered and non clustered index work?
Does sql server 2000 full-text search support clustering?
What is oltp (online transaction processing)?
How to connect a database with sql express.?
What is user defined datatypes and when you should go for them?
