Interested to Buy Any Domain ? << Click Here >> for more details...
could you please reply for these question:
1.About Use Apply?
2.Avoid cursors - When we have a situation that we can not
avoid the use of cursor than what is the alternate solution?
is there anything we can use instead of cursor to perform
the desired task? which optiomize the peroformance too.
3.What is computed columns?
Thanks in advance.
Regards,
Rupesh
- 3 Answers
- 5745 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasanna
Use derived columns,corelated subqueries instead of cursors
so that the performance will also be improved.
Regards
prasanna
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is SQL Azure Data sync?
What is change tracking in sql server?
What is rank function?
What is the beast way to write CTE in SQL Server ?
What are the main differences between #temp tables and @table variables and which one is preferred?
Please illustrate physical database architecture? : SQL Server Architecture
Explain what is lock escalation?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What are different types of table joins?
Can you explain what are various ways to enhance the ssrs report?
how can a database be repaired? : Sql server administration
What are the 2 types of classifications of constraints in the sql server?
What is local temp table?
What is best institute to Learn DotNET And SQL in chennai?
Explain the collation?
