SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

SQL Server optimization series - query recompilation gotchas

published 404 days, 2 hours, 22 minutes ago posted by

sa 412 days, 2 hours, 55 minutes ago

SQL Server optimization series - query recompilation gotchas

What causes the query to recompile? Is it a good sign or bad sign for performance? How frequently should I recompile the stored procedures? Does a reindex cause SP to recompile when it is executed next time? These are quick questions raised in the recent times that I have recieved via emails/forums/user groups, the real response for the above questions varies on version to version. By default the optimization of stored procedure - recompile: will occur when that SP is executed for first time and...(read more)

category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code

tags: benchmarking, Best Practices, Optimization, Performance, query plan, recompile, SQL Server, statiscs age, stored procedure

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

SQL Server optimization series - query recompilation gotchas

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up