- 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!!
No comments:
Post a Comment