Bad Habits: Avoiding NULL in SQL Server.
 
Analyze an actual execution plan.
 
SQL SERVER – Avoid Functions in the WHERE Clause for Performance.
 
Subqueries and Joins for Running Aggregates.
 
Write International Transact-SQL Statements.
 
Allways Choose the right type for your data.
 
NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: SQL Server.
 
Generate a text file and FTP it using a SQL Stored Procedure.
 
Find Text in Stored Procedure, Function, View, or Trigger.
 
Trilha do programador transact-sql sr.
Top 10 reasons of slow SQL code.
 
which is best for performance filtering on where or filtering on join ?