How can I know what locks are running on which resource?


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

Post New Answer

More SQL Server Interview Questions

What is the contrast amongst drop and truncate?

0 Answers  


Where in ms sql server is ’100’ equal to ‘0’?

0 Answers  


What is index?

1 Answers   Cap Gemini,


How real and float literal values are rounded?

0 Answers  


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

0 Answers  






Explain the creation and execution of a user-defined function in the sql server?

0 Answers  


How does using a separate hard drive for several database objects improves performance right away?

0 Answers  


How to sort the query output with order by clauses in ms sql server?

0 Answers  


How to access the deleted record of an event?

0 Answers  


what operator performs pattern matching?

2 Answers  


How the authentication mode can be changed?

0 Answers  


What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

0 Answers  


Categories