What is raiseerror? What is raiseerror?
What is the difference between varchar and varchar(max) datatypes?
What is the difference between seek predicate and predicate?
What is the correct order of the logical query processing phases?
Where in ms sql server is ’100’ equal to ‘0’?
Explain iaas, paas and saas?
Explain the Ways to improve the performance of a sql azure database?
What are parameterized reports?
Differentiate sql server reporting services vs. Crystal reports?
What are cascading parameters in ssrs reports?
What are sub reports?
How to create sub reports?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
Explain lock escalation? : Transact sql