Why and when do stored procedure recompile?


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

Post New Answer

More SQL Server Interview Questions

What is auditing in sql server?

0 Answers  


When do you think a developer should use sql server-based cursors?

0 Answers  


What is the basic difference between clustered and a non-clustered index?

9 Answers   Infogain,


How can you insert null values in a column while inserting the data?

0 Answers  


2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,


how do u do Performance tunning ?

1 Answers   Infodat Technologies, Satyam,


Can group functions be used in the order by clause in ms sql server?

0 Answers  


Describe how to use linked server?

0 Answers  


What is updatable resultset?

0 Answers  


What is INTVAL( )and where we use Plz any body help me

1 Answers  


How to use linked server?

0 Answers  


what kind of lan types do you know? : Sql server database administration

0 Answers  


Categories