Recent Blog ArticlesNewest TopicsMost LikesTagged:TagIntermittent ANONYMOUS LOGON of SQL Server linked server double hop If you already know how to configure the double-hop for SQL Server linked server, you may go "RARE SCENARIO" section directly. Kerberos Delegation (double-hop scenario ) Here we will use ...How to configure the WSFC AG failover policy when the database level health detection enabled? The database level health detection failover option introduced on this article https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/sql-server-always-on-database-health-...Rowgoal impacts the estimated row The engineer asked me a question, how does the optimizer estimate the row for index scan(range scan). he observed 100-109 estimated row for index scan but he wants to know the reason. ...How to manually reuse the identity range under the merge replication when you choose the auto manage the identity range on the merge replication, and some subscriptions dropped, that identity range could not reuse. see this sample: this sample used too ...REQUIRED_SYNCHRONIZED_SECONDARIES_TO_COMMIT and error 988 --SQL 2017 AlwaysOn Recently we got the issue from customer, they failed to add the database into the existing AG with error 988: Msg 988, Level 14, State 1, Line 17 Unable to access database 'ag_03' because it lack...
MicrosoftMicrosoftMicrosoftMicrosoft
