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...

Manual SP to Index Defrag a SQL 2000 database on SQL 2005 that run at spesific times at night  Read more...

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

Index maintenance procedure using rebuild or reorganized based on fragementation level.  Read more...

Creates a resultset that expresses the last time a successful CHECKDB was performed on every database in the instance. Does not work on SQL 2000.  Read more...

Row counts and storage space information for all tables in the database.  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 allows a player to play tic tac toe against an automated computer.  Read more...

Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005.  Read more...

Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.  Read more...

This scalar function accepts a table name and returns the number of bytes left out of the 8060 bytes available for adding new columns.   Read more...

The script shows one of ways generating number sequence - this one uses CTE  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 a specified text in all (or one selected) databases in all (or selected) tables.  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...

This procedure generates a dataset with combinations of elements_to_select taken from number_of_values element set. It prints also the prepared query.   Read more...

This script shows one on ways of generating permutations.  Read more...

Parses up & down the dependency chain of an object  Read more...

This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.  Read more...

This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.  Read more...

Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005.  Read more...

Script to backup 2000/2005 databases.  Read more...