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.
SQL SERVER – 2005 – Use Always Outer Join Clause instead of (*= and =*)
My friend’s queries failed in SQL Server 2005 because they used *= and =* for joins. Always use the LEFT or RIGHT outer join clause instead.
SQL SERVER – 2005 – No Backup Support For Named Pipes
SQL Server 2000 had backup support for named pipes, but SQL Server 2005 only backs up to disk and tape. I also share how we back up our own databases.
SQL SERVER – FIX : Error : msg 2540 – The system cannot self repair this error
Msg 2540 means the system cannot self repair this error, usually corrupt metadata or system files. My fix order: restore the backup, DBCC repair, check hardware.