Query which was working fine all the time suddenly got slow. List three most important priorities to resolve this issue.

Inline table-valued functions are sometimes called 'parameterized views'. This is under the assumption that they provide *all* the functionality that a view provides plus the ability to add parameters. In what other ways are inline table-valued functions different from views?

Sessions - Execution Plan

How will you restrict users at certain period?

Assuming the cache has not been flushed, how can you report on the last time a specific stored procedure was executed?

How do we calculate Total Query Response Time?

This question tries to assess your understanding of SQL Server Transaction logs and invites thoughtful discussion on best practices for managing transaction logs

Given a deployment for databases. Tabulate how the various RAID Levels can be compared against different attributes of Reliability, Storage Efficiency, cost etc. We would also love to hear on your common deployments and best practices in your Organization.

What are possible techniques a DBA can use to handle high fragmentation arising from GUIDs?

Filtered Index Error Conditions