Data Warehousing

Script

This script can be used to display the number of rows of all the tables in a database.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-01-02

321 reads

Discuss

Frequency of each field in table

by Brian Nordberg

SQLServerCentral

Data Warehousing

Script

This SP will generate the frequency of each occurrence in a field or for every field in a table. The syntax isexex sp_freqall , , , , for example:exec sp_freqall utems2000_2001, null,lastname, 100would return a table (with a field name and a count) for each field in the utems2000_2001 table, except the lastname field and […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2002-10-03

235 reads

Discuss

Get table sizes and rowcounts in MB (for VLDB)

by Mike Pearson

SQLServerCentral

Data Warehousing

Script

This simple script is based on sp_spacedused, but returns values for all user tables in the database, with information in MB instead of the usual KB - which is useful for large databases. Simply run it in query analyser against the database concerned

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2002-05-03

753 reads

Discuss

Disk usage for the databases and tempdb.

by Prakash Heda

SQLServerCentral

Data Warehousing

Script

This procedure will return size of the data files & log files of the database and tempdb. This is returned in one resultset so you can use this procedure to store fluctuation in database sizes.