Jonathan Allen's questions

有没有办法直接从 SSMS 启动 SQL Server？

我问是因为我经常直接进入SSMS，才发现我还没有启动SQL Server服务。这意味着要么运行不同的应用程序，要么弄乱命令提示符。

有没有办法分离数据库而不删除它？

有关如何处理此错误的任何建议：

TITLE: Microsoft SQL Server 2017 Setup
------------------------------

The following error has occurred:

VS Shell installation has failed with exit code 1638.

For help, click: https://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=14.0.1000.169&EvtType=0x5B39C8B9%25401434%25403

------------------------------
BUTTONS:

OK
------------------------------

这是一台正在运行的新笔记本电脑

• SQL Server 2016 速成版
• 视觉工作室 2017
• SSMS 2017

我尝试卸载与 SQL Server 或 Visual Studio 相关的任何内容。

日志：[3500:3970][2017-11-03T16:25:20]e000：错误 0x80070666：安装较新版本时无法安装产品。

Detailed results:
  Feature:                       Full-Text and Semantic Extractions for Search
  Status:                        Failed
  Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
  Next Step:                     Use the following information to resolve the error, and then try the setup process again.
  Component name:                Microsoft Visual C++ 2015 Redistributable
  Component error code:          1638
  Component log file:            C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20171103_162358\VCRuntime140_x64_Cpu64_1.log
  Error description:             VS Shell installation has failed with exit code 1638.
  Error help link:               https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=14.0.1000.169&EvtType=VCRuntime140_x64%40Install%400x1638

  Feature:                       Database Engine Services
  Status:                        Failed
  Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
  Next Step:                     Use the following information to resolve the error, and then try the setup process again.
  Component name:                Microsoft Visual C++ 2015 Redistributable
  Component error code:          1638
  Component log file:            C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20171103_162358\VCRuntime140_x64_Cpu64_1.log
  Error description:             VS Shell installation has failed with exit code 1638.
  Error help link:               https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=14.0.1000.169&EvtType=VCRuntime140_x64%40Install%400x1638

架构绑定视图会影响 SQL Server 中的性能还是只是为了防止意外更改？

我最近继承了一个使用BINARY(16)而不是UNIQUEIDENTIFIER存储 Guid 的 SQL Server 数据库。它对包括主键在内的所有内容都执行此操作。

我应该担心吗？

我有一组需要按特定顺序运行的脚本。我想创建一个“主文件”，列出所有其他文件及其正确顺序。基本上就像来自 C++ 或 ASP/VBScript 的包含文件。

在生产环境中，单个 MySQL 服务器使用的最大内核数是多少？