What do you understand by the denormalisation?
What is cursor in ms sql server?
Can a table be moved to different filegroup?
What is Index Segmentation ?
How can I check if a view exists in a sql server database?
Explain optimistic and pessimistic concurrency?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
What is mean by candidate key?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
What is the sql profiler?
Explain in brief how sql server enhances scalability of the database system?
Equi join and non equi join is possible with sql server?
Explain what is lock escalation and what is its purpose?