Utility stored procedure to create non-xml format file for BCP/BULK INSERT processes. Very useful for text-qualified CSV files.  Read more...

Script to find the SQL Server Instance Install Date  Read more...

Generates prime numbers and puts them into a table for future reference by adhoc queries and database and application code. 100% set-based. DDL embedded.  Read more...

Script to find the TCP/IP Port number of SQL Instance  Read more...

Very simple function code to add leading zeros to a passed in int for a length also passed.  Read more...

This function will return a string in sortable format YYYYMMDD-hhmmssnnn to append to file names for archiving.  Read more...

Will find the Table Name, Column Name and the number of occurances some text appears in a database.  Read more...

Edit the @SearchText and you can enter any text you would like to search for in SQL Objects.  Read more...

Here is another "deleting duplicate records" script, this time in-place, using a uniqueidentifier column.  Read more...

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 622, 386884, and 240641848 numbers.  Read more...

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.  Read more...

A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.  Read more...

A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.  Read more...

This procedure works like the sp_spaceused procedure but this one shows statistics for all tables in the selected database or for all databases (excluding tempdb and model).   Read more...

This terse script shows an easy (but "dirty" - so not advisable for production environments - rather for personal use) way to select data from stored procedure.  Read more...

The script shows one of ways generating number sequence - this one uses CTE.  Read more...

This procedure prepares a query for generating permutations of n-numbers set and executes it.  Read more...

The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys').  Read more...

This procedure searches for the specified GUID (or its part) in all (or selected one) databases  Read more...

These examples show how You can circumvent the problem with not working TOP 100 PERCENT and ORDER BY in views.  Read more...