Database Index Size

Note: Column with varchar(max) column type will take up a lot of space and take longer to create. More columns the index cover (include), the more index space it will take up. The Non-cluster Index can use up as much space as Clustered Index if the Non-cluster index includes all the columns in the table.... » read more

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.

Unable to Create Always On Listener Due to Permission Issue

Error: Cluster network name resource ‘XXXX’ failed to create its associated computer object in domain ‘xxxxx’ during: Resource online. The text for the associated error code is: Cannot complete this function. Please work with your domain administrator to ensure that: The cluster identity ‘XXXX$’ has Create Computer Objects permissions. By default all computer objects are... » read more