Cannot delete rows from a temporal history table
Error: Cannot delete rows from a temporal history table xxxxxxx Fix: Reference: https://stackoverflow.com/questions/53746197/cannot-delete-rows-from-a-temporal-history-table
Upgrade availability group replicas
https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/upgrading-always-on-availability-group-replica-instances?view=sql-server-ver16 When upgrading a SQL Server instance that hosts an Always On availability group (AG) to a new SQL Server version, to a new SQL Server service pack or cumulative update, or when installing to a new Windows service pack or cumulative update, you can reduce downtime for the primary replica to only a single... » read more
Things to Avoid in Your Query
LIKE ‘%xxxxxx%’ https://www.brentozar.com/archive/2010/06/sargable-why-string-is-slow/ Table Valued Functions https://www.brentozar.com/blitzcache/tvf-join/ Functions in from/below Implicit Conversions (convert to different data type) Comparing the contents of 2 columns on 1 table Table Variables Table variable does not have stats and serial for updates.
Unable to start Roles in Windows Failover Cluster Manager After DR Test and Doing a Force Start of the Windows Failover Cluster Manager
Replicate the Error Do a DR Test and change the IP address of the server. Without waiting for the IP to completely go into effect, do a Force Start of the Windows Failover Cluster Manager. The cluster will come up but the Roles will unable to be restarted. The nodes will be running. The databases... » read more
CTE (Common Table Expression)
https://learn.microsoft.com/en-us/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-ver16 Specifies a temporary named result set, known as a common table expression (CTE). This is derived from a simple query and defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE or MERGE statement. A Common Table Expression, also called as CTE in short form, is a temporary named result set that... » read more
SQL Server Windows Failover Cluster – Unable to start Roles
Status: Windows Failover Cluster fail to start any of the Roles All nodes in the Windows Failover Cluster are up. Identified several important event IDs that are common across all SQL nodes: 1069, 1205, 1254. Probable Causes: -SQL node names and AG name are not resolving or couldn’t register in the network. please look at the... » read more
ONLINE = ON
ONLINE = ON for SQL Server Enterprise / Developer Edition ONLINE = OFF for SQL Server Standard Edition
UDF (User Defined Functions) and Serialization
Your queries could be going parallel, but because of limitations in SQL Server, they staying serial: single-threaded. A lot of different things can cause this, including running SQL Server Express Edition (which only uses 1 CPU core), but the most common are Scalar UDFs. Generally, there’s not a server-level fix for these: you’re stuck rewriting the... » read more
How to track progress of CREATE INDEX command?
Sources: https://dba.stackexchange.com/questions/139191/sql-server-how-to-track-progress-of-create-index-command
Aligned and Non-Aligned Indexes for Partitioning
Partitioning is a powerful feature in SQL Server, allowing your data to be split across different “partitions”, which are simply smaller, more manageable pieces of a larger table or index. Partitioning can provide substantial performance benefits, especially for large tables, where queries that access only a fraction of the data can run much faster because... » read more