How you can minimize the deadlock situation?

Question Posted / anjani kumar

No Answer is Posted For this Question
Be the First to Post Answer

More SQL Server Interview Questions

what are default? Is there a column to which a default cant be bound?

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

How to create a view with data from multiple tables?

Explain sub-query?

i want table name basis on column name.

CLR Integration ? what is Notification services ?

What are the different types of indexes?

Can we insert data if clustered index is disabled?

After removing a table from database, what other related objects have to be dropped explicitly?

What is cursor ? And what is difference between Trigger ?

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

For more SQL Server Interview Questions Click Here