Author: Peter Whyte

701 is the server unable to find memory at all. 8645 is the memory existing and being held by someone else. Neither one means buy more RAM, and cumulative wait stats will mislead you about both.

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. Msg 3154  ·  Level 16  ·  State 4 The backup set holds a backup of a database other than the existing ‘Sales’ database. Msg 3154, Level 16, State 4 RESTORE DATABASE is terminating abnormally. ⚡Restore alongside rather than over the…

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. Msg 5030  ·  Level 16  ·  State 2 The database could not be exclusively locked to perform the operation. Msg 5030, Level 16, State 2 ⚡Never end a session with the database still in SINGLE_USER. An application pool takes the…

Msg 102 usually is not a typo. If the same statement runs on one database and fails on another, the parser grammar is chosen by compatibility level, not by the version of the instance.

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. Msg 245  ·  Level 16  ·  State 1 Conversion failed when converting the varchar value ‘N/A’ to data type int. ⚡Quote the literal first. int outranks varchar, so an unquoted number makes SQL Server convert the whole column instead of…

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. Msg 547  ·  Level 16  ·  State 0 The DELETE statement conflicted with the REFERENCE constraint “FK_OrderLines_Orders”. The conflict occurred in database “Sales”, table “dbo.OrderLines”, column ‘OrderId’. ⚡Query sys.foreign_keys before you fix anything. SQL Server reports one blocking constraint at…

🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. Msg 208  ·  Level 16  ·  State 1 Invalid object name ‘Orders’. ⚡Run SELECT DB_NAME(), SCHEMA_NAME() before anything else. Four contexts produce this error and three of them are about where you are sitting, not whether the object exists. The…