We have a very large (many millions of rows) table that contains some (few million) rows with invalid values in particular columns.
A stored procedure exists to correct the invalid records but it takes a really long time to run the first time. It is significantly faster after that, as you would expect once the procedure has been compiled and the plan generated and cached. Unfortunately the procedure will probably only be executed once so we don't get the benefit of any optimization the server does during the first execution.
Is there some way to tell SQL Server to compile/generate/estimate an execution plan for a stored procedure before running the procedure?