Do you know concepts and capabilities of sql server?
What is the difference between rank and dense_rank?
What is the difference between for auto and for nested?
What is the advantage of specifying WITH GRANT OPTION in the GRANT command?
How do you simulate a deadlock for testing purposes
Tell me the difference between clustered and non-clustered index?
What are the types of indexing?
sql server architecture ?
Why do we partition data?
Advantages and disadvantages of stored procedures.
How to count rows with the count(*) function in ms sql server?
what do you understand by change data capture?
What can be used instead of trigger?