You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?


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

Post New Answer

More SQL Server Interview Questions

Explain relational data?

0 Answers  


What are the types of containers in ssis?

0 Answers  


What are pages and extents? : SQL Server Architecture

0 Answers  


What is the largest component inside a field?

0 Answers  


What is self contained multi valued query?

0 Answers  






How do triggers work?

0 Answers  


How can you set the threshold at which sql server will generate keysets asynchronously?

0 Answers  


Is sql server a database?

0 Answers  


What is service broker?

0 Answers  


What is statement level trigger?

0 Answers  


What is 2nf normalization form?

0 Answers  


How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

0 Answers  


Categories