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 – FIX: Msg 4335, Level 16, State 1 – The specified STOPAT time is too early
Preparing a point in time restore demo, I got Msg 4335: the specified STOPAT time is too early. Here is what the error means and how to get past it.
SQL SERVER – System.IO.FileNotFoundException: Could not load file or assembly
Deploying a SQLCLR assembly failed with System.IO.FileNotFoundException: Could not load file or assembly. Here is how I debugged it.
SQL SERVER – FIX: Msg 7395, Level 16, State 2 – Unable to start a nested transaction for OLE DB provider
A linked server update in a distributed transaction failed with Msg 7395, unable to start a nested transaction for OLE DB provider. Here is the cause and fix.