When you use @@error and try-catch?

1043

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1034

When to use null data driven subscription?

206

Name some of the open source software that you can use in alternative to SSR?

161

What is a view and what are its advantages?

1112

What is sql server management studio? : sql server management studio

1074

List the different index configurations possible for a table?

934

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1385

What is a recursive stored procedure in sql server?

1175

How to use column default values in insert statements in ms sql server?

1031

Explain multiserver query

1042

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1152

Explain log shipping?

1011

How to get nth highest salary from employee table.

1163

 Explain what is sql override for a source taLle in a mapping?

1012