1.how to find the dead lock in sql server?
2.How to fine the memory leaks in sql server?
3.suppose transaction log file increasing what action will
take ?


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

Post New Answer

More SQL Server Interview Questions

Explain what is row_number function?

0 Answers  


explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

0 Answers  


Explain about service Broker functions?

0 Answers  


What is a join and their types?

2 Answers   Challenger Financial,


what is a schema in sql server 2005? : Sql server database administration

0 Answers  






What is the maximum size per database for sql server express?

0 Answers  


Why do we backup Active Directory ?

0 Answers  


What is normalization? Describe its different types.

0 Answers   Wipro,


1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 Answers  


how to find the second salary?

10 Answers   HCL, Prithvi,


How would you use user_constraints table in DB?

0 Answers   Wipro,


WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 Answers  


Categories