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
- 6047 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 do you understand by hotfixes and patches in sql server?
Why transaction is important?
Explain database normalization?
What is the contrast between sql and pl/sql?
what is raid? : Sql server database administration
How to get the definition of a view out of the sql server?
Where are sql server user names and passwords stored in sql server?
What is cdc in sql server?
Tell me in brief how sql server enhances scalability of the database system?
When would you use it?
What is the purpose of linked server configuration in sql server?
Explain partitioned view?
Tell me what are the advantages of using stored procedures?
What is the difference between ddl and dml?
What is the fillfactor concept in indexes?
