Google Watch Unresponsive
Press and hold the crown and the button above it until the Google Logo appears.
SSMS takes a long time to open up connection for each new query window
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 Setup for SQL Server Always On Setup using Failover Cluster
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
With Index
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.
SET LOCK_TIMEOUT
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.
The Security tab is hidden in Active Directory object properties
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