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 the architecture of ms sql reporting service?

0 Answers  


An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,


What is sql server management studio? : sql server management studio

0 Answers  


Is truncate autocommit?

0 Answers  


What are cursors? Name four types of cursors and when each one would be applied?

3 Answers   Adea Solutions,






What is Schema in Database?

1 Answers   Cap Gemini,


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 ?

0 Answers  


What is the use of sign function?

0 Answers  


What is self contained multi valued query?

0 Answers  


Describe in brief sql server monitoring ways.

0 Answers  


What is the difference between truncate and delete statement?

6 Answers   CarrizalSoft Technologies, CTS,


What are the types of model in sql server and explain

2 Answers   TCS,


Categories