How can you find out which stored procedures are recompiling?


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

Post New Answer

More SQL Server Interview Questions

what is sql injection?

2 Answers  


What happens if null values are involved in comparison operations?

0 Answers  


what is trigger . hw will it use them

2 Answers   TCS,


How to sort query output in descending order in ms sql server?

0 Answers  


What are the disadvantages of merge replication?

0 Answers  






There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers  


can any body tell me how to know the password of current user in sql server

0 Answers   Crea, HCL,


What is global temp table?

0 Answers  


What is mssql?

0 Answers  


in my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?

1 Answers   IBM,


What does it mean if @@cursor_row returns a negative number?

0 Answers  


To find second largest salary in Employee table

17 Answers   CSS,


Categories