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
- 5939 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
How do I find query history in sql server?
Can we check locks in database? If so, how can we do this lock check?
How do you trace the traffic hitting a sql server?
What is the difference in accessing db between sql server vs sql azure?
Ms sql server index?
What part does database design plays a role in performance of an sql server-based application?
How to change the password of a login name in ms sql server?
What is default port number for sql server 2000?
how can you attach more than 20 ldf files in sql server
What is the difference between DATETIME2 and DATETIME?
Explain what is the use of custom fields in report?
What is amo? : sql server analysis services, ssas
What is the beast way to write CTE in SQL Server ?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
How to create function without parameter in sql server?
