A reader asked what Optimistic Multi-Version Concurrency in InMemory OLTP really means. It sounds simple but is a loaded question, so here is a plain answer.
Finding Where an Object Is Used Across a Database
Use dependency metadata, definition searches, and runtime evidence to find object usage while accounting for dynamic SQL and external callers.
SQL SERVER 2016 – IF EXISTS Function on SQL Azure Databases and More
Many SQL Server 2016 features reach Azure SQL Database first. Here is how I checked the IF EXISTS Function and other new features on SQL Azure databases.
SQL SERVER – Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’
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 – 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 – 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.