Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
 Posted - 2005-01-06 : 21:55:00
|
| Hi All,I read from BOL that if you use table as parameter to sp_recompile, all triggers and SPs referring to it will be recompiled, but if trigger or SP is passed, it becomes specific.Question: which is better in terms of resource utilization and/or duration?i plan to schedule this periodically, i know this probably depends on the usage but what's the "best schedule"?TIA--------------------keeping it simple... |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-01-06 : 22:13:14
|
| Recompiles don't take all that long nor use that many resources. Not to mention you'll be recompiling the same objects no matter which method you use. Whatever is simpler for you to code. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-01-07 : 00:03:09
|
thanks for the quick reply rob  --------------------keeping it simple... |
|
|
|
|
|
|
sp_recompile