Issue: SSMS takes a long time to open up connection for each new query window. This applies to all other applications that connects to the database as well. Fix: Disable The Publisher Certificate Check Part of the SSMS start-up routine involves connecting to the Microsoft website to check a certificate list. You can disable this... » read more
Active Directory Need to create 2 AD objects. Cluster Host Listener Host Object needs to be… In the same AD folder. Add self, cluster, all customer hosts to the security tab with full control. Set the object to “Inactive” state. Inactive account. IP address will be enterer in at setup time. No need to add... » read more
Usually the DB engine should automatically select the index to use based on query execution plans it builds. However, there are some pretty rare cases when you want to force the DB to use a specific index.
https://learn.microsoft.com/en-us/sql/t-sql/statements/set-lock-timeout-transact-sql?view=sql-server-ver16 Specifies the number of milliseconds a statement waits for a lock to be released.
Issue: “Security” tab is not visible in the object properties window of Active Directory Users and Computers Resolution: Make sure the following is checked… View -> Advanced Features