Monday, July 18, 2011

Recompiling Stored Procedures

If we edit a stored procedure, it is recompiled the very first time it is executed. So the program using this Stored Procedure may see delay during this period (as it is being recompiled).

But we can force SQL Server to recompile Stored Procedure by using WITH RECOMPILE option

Example:exec usp_TestProcedure WITH RECOMPILE
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

If you’re using Visual Studio to build your .NET MAUI app on a Mac, locating the IPA (iOS App Package) file can be a bit tricky

  If you’re using   Visual Studio   to build your   .NET MAUI   app on a   Mac , locating the   IPA (iOS App Package)   file can be a bit tr...