Functions

• Phone Numbers
• fn CURDATE()

How To

• Cast and Convert
• Change Tracking example
• Compact SQL logs for one database
• Compate SQL logs for all databases
• Configure SQL database mail on a SQL 2005 or 2008 server
• Create a Stored Procedure with OUTPUT Parameters
• Create a table of US States
• CTE (Common Table Expression) Example
• Cursor Template 
• Determine if a SQL field contains an alpha character
• Dump SQL Objects (stored procedures, views) to a text file
• Dynamic Management Views Primer
• Dynamic Where Clause
• Inserting the results of a stored procedure to a temp table
• Find out how big your SQL tables are
• Find tables that contain a certain field
• Getting a ‘percent changed’ figure in SQL 2005 (or better)
• Get the column names on all the indexes for one table in SQL Server 2008
• Getting the most recent value in a group from a table
• Grouping By Grouping Sets examples
• Handle a DYNAMIC ORDER BY clause
• Loop through a Stored Procedure (or View, or Trigger…) one character at a time
• MERGE statement example
• Parse a comma separated string into a SQL table
• Programmatically Kill SPIDs
• RAISERROR Template
• Regex: Searching for lines that have one string but are missing another
• Making SQL 'Sleep'
• Read / Set the Recovery Model of a database 
• Semicolon or Comma separated contatoncated output in SQL Server 
• Send the results of a stored procedure into a table
• SQL SMO class
• How to tell if a temp table exists
• Truncate the Log Size of All Databases on a SQL Server
• Use @@ProcID
• View all the Parameters for a Stored Procedure
   

DDL

• Create Index script
• Script to Audit Tables
• Showplan Operators

SQL XML

• Examples from Microsoft
• How to query an XML field in SQL Server
• How to read an attribute from an XML field in SQL Server 2005
• Return one XML field with the contents of a table

 Reporting Services (SSRS)

•  Get a running total