Posts on SQL

SQL - Clustered Index

SQL - Date - BOM & EOM

SQL - Date - EOM DB2

SQL - Using CTE in Recursive Query

SQL - Using CTE to "Pivot" Table

SQL - Using Information_Schema View

SQL – UPDATE Statement with JOIN

SQL – Openquery (3) Delete & Insert

SQL – Openquery (2) Pass Parameters

SQL – Openquery (1) Use It Or Not Use It

SQL – Remove Time from Datetime Field

SQL – Remove Duplicates Max, Group by

SQL – Index Clustered vs Non-Clustered

SQL – Denormalization & Normalization

SQL – Confused by keys?