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

What is the template in sql?

0 Answers  


I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers  


What Are Three Rules to UseĀ UNION IN SQL SERVER

1 Answers  


What are the 10 characteristics of data quality?

0 Answers  


What are the tool windows in sql server management studio? : sql server management studio

0 Answers  






Explain the database you used in your final year project?

0 Answers   Wipro,


Introduction of rollup clause using sum and group by clause?

0 Answers  


Please explain what is “asynchronous” communication in sql server service broker?

0 Answers  


It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

0 Answers  


List down some advantages of sql stored procedure?

0 Answers  


what is cursor?why we will go to cursor?advantages &disadvantages of cursors?

1 Answers  


How to get the number of affected rows?

0 Answers  


Categories