A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.  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...

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

The script shows one of ways generating number sequence - this one uses CTE.  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...

Utility stored procedure to create non-xml format file for BCP/BULK INSERT processes. Very useful for text-qualified CSV files.  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...

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

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

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 generates a dataset with combinations of elements_to_select taken from number_of_values element set. It prints also the prepared query.   Read more...

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

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

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

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

Continuing on with a look at SQL Server 205 partitioning features, Andy Warren delves into archiving techniques.   Read more...

Auditing is something that almost every DBA needs to tackle at some point in his or her career. David McKinney brings a new twist on the solution by using XML and XSL to help implement auditing in your SQL Server application.   Read more...