积极答复者
请问大家有什么好的SQLSERVER工具啊,谢谢!

问题
答案
-
比如,查找某个值在哪个表里、表的行数、重复的索引、缺少的索引,代码格式化方面等等
Hi Tim-2009,
您好!根据您的要求,给出建议如下:
1.查找某个值在哪个表里,表的行数;
-->这个只要编写SQL语句即可。
2.重复的索引、缺少的索引,
--> 建议您使用 Database Engine Tuning Advisor
3 其它用途工具:
Display an Actual Execution Plan 评估SQL查询语句执行效率
SQL Server Profiler 监控数据库引擎或分析服务的实例
以上工具用得比较多,你可以点击相关链接进行了解。
Best Regards,
Will
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
- 已编辑 Will_KongMicrosoft contingent staff 2017年9月28日 9:12
- 已标记为答案 Tim-2009 2017年9月30日 3:20
全部回复
-
Hi Tim-2009,
您好!请问您需要什么方面用途的工具呢?请提供一些用途需求,方便提供可选择的工具,谢谢。
Best Regards,
Will
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com. -
Hi Tim-2009,
您好!请问您需要什么方面用途的工具呢?请提供一些用途需求,方便提供可选择的工具,谢谢。
Best Regards,
Will
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
比如,查找某个值在哪个表里、表的行数、重复的索引、缺少的索引,代码格式化方面等等 -
比如,查找某个值在哪个表里、表的行数、重复的索引、缺少的索引,代码格式化方面等等
Hi Tim-2009,
您好!根据您的要求,给出建议如下:
1.查找某个值在哪个表里,表的行数;
-->这个只要编写SQL语句即可。
2.重复的索引、缺少的索引,
--> 建议您使用 Database Engine Tuning Advisor
3 其它用途工具:
Display an Actual Execution Plan 评估SQL查询语句执行效率
SQL Server Profiler 监控数据库引擎或分析服务的实例
以上工具用得比较多,你可以点击相关链接进行了解。
Best Regards,
Will
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
- 已编辑 Will_KongMicrosoft contingent staff 2017年9月28日 9:12
- 已标记为答案 Tim-2009 2017年9月30日 3:20