Let us say master db itself has no backup. Now you have to
rebuild the db so what kind of action do you take?
Do you know spatial data types - geometry and geography in sql server 2008?
What is an execution plan? When would you use it? How would you view the execution plan?
What are the basic functions for master, msdb, model, tempdb and resource databases?
What is row_number () and partition by in sql server?
Can you explain different types of locks in sql server?
How do you know which index a table is using?
what is differece between union and union all
Define a cross join?
What is the basic functions for master, msdb, tempdb databases?
How to enable/disable indexes?
What is stored procedures?
What happens if null values are involved in datetime operations?