SQLServerCentral.com Scripts tagged tally

Prime Number Table Generator (new ver crunches to 1 Mil in <10.5 sec!)

Wed, 15 Jul 2009 06:00:00 UT

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.

Delimited String Parsing Functions - TwoCol set

Mon, 03 Nov 2008 07:00:00 UT

Feed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

Delimited String Parsing Functions - Big2D set

Wed, 22 Oct 2008 06:00:00 UT

Feed it large strings of double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.

Delimited String Parsing Functions - 2D set

Tue, 14 Oct 2008 06:00:00 UT

Feed it double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.

Delimited String Parsing Functions - Big Set

Wed, 06 Aug 2008 03:03:20 UT

Feed it large strings of delimited horizontal data and it returns it back as a vertical table.

Delimited String Parsing Functions - Basic Set

Mon, 20 Oct 2008 06:00:00 UT

Feed it delimited horizontal data and it returns it back as a vertical table.

Counter Table (table of numbers) Setter-Upper for SQL Server 2005

Wed, 06 Aug 2008 02:57:05 UT

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

Counter Table (table of numbers) Setter-Upper for SQL Server 2000

Wed, 06 Aug 2008 02:50:45 UT

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

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.