I was executing the script I found on this site to mark all my tables and stored procedures for recompilation.
(I changed it to also mark the stored procedures)
I have a Windows Forms (.net 3.5) application which uses a lot of data tables and after executing this script the time it took to open a data heavy form went from 8 seconds to just 4 seconds.
Do I have to run such a script regularily? I thought SQL Server would take care of compiling procedures and such.
BTW: Should this question be on SO? I thought the DBAs would be here on SF.