This Function is written to split Multivalued Parameter passed by Reporting Services 2005.  Read more...

This script maps the primary key - foreign key relations regardless if the column names are the same or not.  Read more...

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

Read more...

Three different ways that you can get the count of the rows in a table.  Read more...

Get space for all user defined table information like size and row counts.  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...

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

What is the fastest way to update a newly created column in a large table? New author Bimal Fernando brings us a look at a technique he uses for just this situation.   Read more...

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

Have you ever wanted to ensure that keywords in your data are easily searchable? Have you struggled with full-text search? New author Michael Ahmadi brings us an interesting idea for a keyword tracking and searching subsystem based on T-SQL and triggers.   Read more...

When automating administrative actions for SQL Server, there are a number of ways to handle the workflow. Longtime SQL Server DBA Roy Carlson brings us a technique for using a text file as input to the standard SQL Server tools.   Read more...

This script maps the primary key - foreign key relations regardless if the column names are the same or not.  Read more...

The use of bitmasking is usually limited to decoding values in the system views, but it can be useful in other places when you want to save space. New author Lee Everest brings us an introduction to bitmasking and its use in SQL Server 2005.   Read more...