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
- 5122 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 view a trc file?
What is "scheduled jobs" or "scheduled tasks"?
Sql server reporting services vs. Crystal reports.
What is SQL Azure Federations?
What are the 3 types of schema?
Give an example of SQL injection attack ?
How to add an address record into adventureworkslt?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What is isolation levels?
What is the use of set nocount on/off statement?
How do I open port 1433?
What are the disadvantages of using querystrings to send data from one page to another?
What to check if a User database is locked?
what are acid properties? : Sql server database administration
What information is maintained within the msdb database?
