After a patch, my SQL Server would not start because upgrade step ‘sqlagent100_msdb_upgrade.sql’ failed with error 537. Here is how I fixed it.
SQL SERVER – 2016 Error Reasons: Msg 10778, Level 16 Foreign key relationships between memory optimized tables and non-memory optimized tables are not supported
Msg 10778 says foreign key relationships between memory optimized and non-memory optimized tables are not supported. Here is why.
SQL SERVER – Fixing Annoying Network Binding Order Error – Notes from the Field #112
Ryan Adams explains a critical SQL Server error about network binding order and shows how to fix it in this Notes from the Field episode.
SQL SERVER – Add failover cluster node fails with “number of cluster nodes supported for edition”
Add failover cluster node fails with number of cluster nodes supported for edition. Here is what the error means and how to fix it.
SQL SERVER – Timeout expired. The timeout period elapsed prior to completion of the operation
Today we are going to learn about how to fix the error: Timeout expired. The timeout period elapsed prior to the completion of the operation.
SQL SERVER – Why is My Query Switching to Row Processing and Not Doing Batch Processing?
Why is my query switching to row processing and not doing batch processing? Here is what to check with ColumnStore indexes in SQL Server.
Interview Question of the Week #055 – How to Convert ASCII to DECIMAL or DECIMAL to ASCII?
Interview question: how do you convert ASCII to DECIMAL or DECIMAL to ASCII in SQL Server? The answer uses two simple built-in functions.