开发者

Generate Multiple Scripts from SQL Server Query Optimizer

I looked around but couldn't find an answer to this question so I figured I wou开发者_高级运维ld ask. So I am in the process of using the SQL Server query optimizer on several long stored procedures. When the optimizer is done, that am getting lots of suggestions to create stats and indexes but it is displayed on one line at a time.

Is there a way to create all of the scripts at once? Then I copy have to click each line to create my scripts and then copy to clipboard and then execute each one


So I found the answer to this. In the Database Engine Tuning Advisor, Under the Actions menus > Save Recommendations.

This will save all of the scripts in one file

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜