What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
No Answer is Posted For this Question
Be the First to Post Answer
How can we rewrite sub-queries into simple select statements or with joins?
What is sqlservr.exe - process - sql server (sqlex?press)?
What is difference between stored procedure and user defined function?
How do I start sql server agent automatically?
Suggest a method of joining two tables.
0 Answers Ernst Young, Thomson Reuters,
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
What is bcp? When does it used?
How would you choose between a clustered and a non-clustered index?
What is the maximum size of a row in sql server?
How can you see what type of locks used?
When is the use of update_statistics command?
What is DAC? what is the use of it?