Error: 4861: Cannot bulk load because the file could not be opened. Operating system error code 1326 (The user name or password is incorrect.). Fix: This error message “Cannot bulk load because the file could not be opened. Operating system error code 1326 (The user name or password is incorrect.)” means that your SQL Server is... » read more
https://stackoverflow.com/questions/30597429/how-to-clear-cache-of-1-stored-procedure-in-sql-server
Issue: Certain SQL Server job get stuck and unable to finish. When run manually, the code finish running, but when it runs via SQL Server Agent, it never finishes. Fix: Restart SQL Server.
Issue: Getting the following when trying to shrink the database. Error: Could not adjust the space allocation for file ‘xxxxxxxxx’.Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed. (Microsoft SQL Server, Error:... » read more
https://pragmaticworks.com/blog/table-partitioning-in-sql-server-partition-switching Partition switching moves entire partitions between tables almost instantly. It is extremely fast because it is a metadata-only operation that updates the location of the data, no data is physically moved. New data can be loaded to separate tables and then switched in, old data can be switched out to separate tables and then archived or purged.... » read more
Sources: https://pragmaticworks.com/blog/table-partitioning-in-sql-server-partition-switching
https://blog.coeo.com/five-cool-things-you-can-do-using-partitioning Move files to another location without affecting the availability of the database. Rebuild part of our data using different compression/fill factor settings. Setting part of our data to be READ_ONLY. Quickly remove old data without incurring in high log usage. … Partial backups and restores.
Task: Designate all nodes as possible owners for DB01 and DB02 to ensure the cluster resource comes online automatically after a failover. Steps: To designate all nodes as possible owners for resources like DB01 and DB02 in a Windows Server Failover Cluster (WSFC), you can follow these steps. This ensures that the cluster resource comes... » read more
Create Index Progress Sources: https://dba.stackexchange.com/questions/139191/sql-server-how-to-track-progress-of-create-index-command/139225
Note: Run the SQLServer2019-KB5039747-x64.exe file to start the patch. An GUI similar to the SQL Server Install will popup to guide you through the patch process. Make sure SQL Server services has been stopped. Make sure to restart the server after the patch has completed. After the restart, the SQL Server version should reflect what... » read more