Some real SQL Server error messages read like jokes. Here are my favorite funny SQL Server error messages and what each one is really telling you.
RADIANS: Cast Integer Degrees Before Conversion
RADIANS changes degrees into radians, but its input type affects the result. The example contrasts integer and float arguments while keeping the original degree values.
SQL SERVER – 2005 – Find Tables With Primary Key Constraint in Database
A script to find tables with primary key constraint in a SQL Server 2005 database, listing the index name, table name and column name from sys.indexes.
SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database
A foreign key inventory needs both the constraint and its column pairings. I include schema names to identify each table clearly.
SQL SERVER – 2005 – Search Stored Procedure Code – Search Stored Procedure Text
How to search stored procedure code in SQL Server 2005 for a table or column name, using sys.procedures and OBJECT_DEFINITION instead of sp_depends.
SQL SERVER – Fix : Error : Msg 3117, Level 16, State 4 The log or differential backup cannot be restored because no files are ready to rollforward
Msg 3117 means the log or differential backup cannot be restored because no files are ready to rollforward. Restore the full backup WITH NORECOVERY first.
SQL SERVER – 2005 – Find Database Status Using sys.databases or DATABASEPROPERTYEX
Find database status such as ONLINE, OFFLINE, RESTORING or SUSPECT using sys.databases or DATABASEPROPERTYEX, and learn what each status means.
SQL SERVER – 2005 – Find Database Collation Using T-SQL and SSMS
Two ways to check database collation using T-SQL and SSMS in SQL Server 2005, and why DATABASEPROPERTYEX in T-SQL is the one I recommend.
SQL SERVER – Difference and Explanation among DECIMAL, FLOAT and NUMERIC
What is the difference between Decimal and Numeric? None, they are the same. Float is different: it is approximate, while Decimal keeps exact precision.
SQL SERVER – Actual Execution Plan vs. Estimated Execution Plan
Actual Execution Plan or Estimated Execution Plan? I always use the actual plan because it is accurate. Shortcuts: CTRL+M for actual, CTRL+L for estimated.