Simple way to find errors in SQL Server error log

Error Handling in SQL Server with Try Catch

Invalid Column Name SQL: Why It Occurs and How to Quickly Fix It - Position Is Everything

A DBA guide to SQL Server performance troubleshooting – Part 1 – Problems and performance metrics

Common SQL syntax errors and how to resolve them

How to resolve deadlocks in SQL Server

Understanding Query Optimization in SQL Server

Query optimization techniques in SQL Server: the basics

SQL Query Optimization - Tips and Techniques