Interested to Buy Any Domain ? << Click Here >> for more details...
Which is best Subquery (or) joins in sql server? explain why
- 2 Answers
- 11201 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
Name three of the features managed by the surface area configuration tool? : sql server security
How to create an multi-statement table-valued function?
What are the differences between user defined functions and stored procedures?
Do you know the capabilities of cursors?
what type of index will get created after executing the above statement? : Sql server database administration
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
Explain the truncate command?
What command is used to rename the database?
What are different types of raid configurations? : SQL Server Architecture
What is compression - row-level and page-level compression?
How to end a stored procedure properly in ms sql server?
How to count rows with the count(*) function in ms sql server?
What is difference between drop truncate and delete?
What is acid mean in sql server?
Can we take the full database backup in log shipping?
