What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
Is BCNF better than 2NF & 3NF? Why?
Does partitioning improve performance?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
Can you explain various data region available in ssrs with their use?
How to convert numeric values to integers in ms sql server?
What is “asynchronous” communication in sql server service broker?
What is lookup override?
How to create an identity column?
How fixed length strings are truncated and padded?
Explain about sql server login?
How to fetch the next row from a cursor with a "fetch" statement?
How to query multiple tables jointly?
What is subquery explain with example?
What is sql server locking?