2019 年 2月随笔档案 - stswordman

FILESTREAM feature can't be enabled if you use cluster shared volumes

摘要：Create a SQL Cluster instance. Create Cluster Shared Volume Please note. No Share storage is added into SQL Server. Open SQL Server configuration mana 阅读全文

posted @ 2019-02-22 03:29 stswordman 阅读(430) 评论(0) 推荐(0) 编辑

SQL Server does not purge row versioning records even the transaction are committed if there are other open transaction running in the databases with read-committed snapshot enabled .

摘要：This is a by-design behavior. There is only one allocation unit in tempdb that istracking the versioned records across the server. Cleanup of this all 阅读全文

posted @ 2019-02-22 02:19 stswordman 阅读(172) 评论(0) 推荐(0) 编辑

“The subscription does not exist” when a distributor primary replica fails over to a replica that does not use the same agent profile

摘要：Symptoms  Consider the following scenario: In Microsoft SQL Server 2017, 阅读全文

posted @ 2019-02-09 05:36 stswordman 阅读(511) 评论(0) 推荐(0) 编辑