SQL Server Programming Hacks
Denis Gobo has just gathered a great selection of what he calls "a collection of frequently asked questions" and posted them in a new collection called SQL Server Programming Hacks. These include hacks from various categories such as:
* 1 NULLS
* 2 Dates
* 3 Sorting, Limiting Ranking, Transposing and Pivoting
* 4 Handy tricks
* 5 Pitfalls
* 6 Query Optimization
* 7 Undocumented but handy
* 8 Useful Admin stuff For The Developer
Check out the full list here: