TSQL

1. Unveal Difference Between ON and WHERE Clause When Used With Joins In SQL Server
2. Which Kind of Table Expression to Use: Common Table Expressions, Views, TVFs, or Derived Tables?
3. How to: Pad a Number with Leading Zeros
4. Implicit Conversion From Varchar to Datetime
5. How to: Check Transaction Isolation Levels
6. How to: Set Row Versioning-based Transaction Isolation Levels 
7. Is Truncate DDL or DML?
8. How to: Use Check Constraints to Enforce Business Rules
9. How to: Do Incremental Loading by Hashbytes Function with Stored Proc?
10. Difference Between COALESCE and ISNULL
11. Show Line Number in SQL Server Management Studio

SQL Server 2012

1. TRY_CONVERT, TRY_CAST to Find Failed Data Conversion