TSQL Developer Tip of the Day

This post is focussed on TSQL Developer focussed tips. I have bookmarked few important reads.

• Generating a Database Data Dictionary
• Create data dictionary of metadata in SQL Server 2008
• Database Documentation
• OUTPUT clause in INSERT/UPDATE/DELETE statements
• CTEs (Common Table Expressions)
• SQL SERVER – 2005 Best Practices Analyzer Tutorial – Sample Example
• EXEC and sp_executesql - how are they different?
• Cool new OVER Clause (Transact-SQL) in SQL Server 2005
• SQL Server 2005 ranking functions - ROW_NUMBER()
• SQL 2005 - TSQL Enhancements
• SQL Server 2005 UNPIVOT Command - changings columns to rows (normalizing)
• The PIVOT Operator
• The UNPIVOT Operator
• Great Presentation on TSQL Coding Styles - "T-SQL : Bad Habits to Kick"
• What I Wish Developers Knew About SQL Server Presentation.
• Find all tables with or without an IDENTITY column

Happy Reading!!