Scripts by Rafal Skotak

Procedure tries to kill all connections to the specified database.  Read more...

This procedure is supposed to compare structure (tables, procedures, triggers, foraign keys etc.) of two specified databases.  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 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...

Created view displays all text columns' collations in the current database with the information whether the collation is different from the database's one.  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...

This procedure generates a list of random varchars (8 charactes length, only letters - lower or upper case).  Read more...

Procedure changes all databases' recovery mode to simple and shrinks them all (or at least it tries to).  Read more...

This procedure displays amount of disk space used by database per directories.  Read more...

Two queries below show one of many ways how You can generate a sequence of numbers.  Read more...

Functions return tables with days of the specified month.  Read more...