TSQL Utilities

» Numberline

A table with numbers from 0..n is a useful tool in SQL. This script creates a table and populates it with numbers from 0 to 100,000.

» Date Dimension

SQL to create a custom date dimension for use in reporting. Days are uniquely identified by an integer instead of datetime.

» sp_standardize_names

A stored procedure to help "standardize" the system generated names with numeric suffixes that SQL Server creates. Sytem generated names can be a hinderance when creating update scripts.

» sp_script_column_defaults

A stored procedure that generates TSQL to define column defaults. This is useful when "cloning" a table using the non-logged "select .. into" construct.

» url_unescape

A TSQL function to unescape a URL encoded string.

» Bulk Load

Copy a file into a table using both BULK LOAD and OPENROWSET

Performance