What is PROJECTION Operation?
What are the different types of cursor?
List the different types of joins?
Why do we use trigger?
Explain the architecture of ms sql reporting service?
What is data compression?
Write a SQL queries on Self Join and Inner Join.
What is the difference between seek predicate and predicate?
Why would you use sql agent?
What happens on checkpoint?
How to create a large table with random data for index testing in ms sql server?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
Which are ddl commands?
what is difference between NULL and ISNULL in SQL Server 2008?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?