Brian Nordberg

Finding Similar Data Using SQL Server Integration Services

SQL Server 2005 has greatly increased the capabilities of the platform and brought the capabilities for complex ETL packages to many businesses at an affordable cost. One of the very interesting transformations you can use in SSIS is the fuzzy grouping task and new author Brian Nordberg brings us a look at how you can use this.

4.44 (9)

2007-07-16

8,231 reads

Frequency of each field in table

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 […]

2002-10-03

219 reads

Blogs

Daily Coping–3 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Data Céilí 2020 Cancelled

By

Yesterday we announced that Data Céilí 2020 has been cancelled due to the continuing...

Code from Redgate Streamed

By

I presented a session today at Redgate Streamed and did a number of demos....

Read the latest Blogs

Forums

Need T-SQL to list all tables in database that 'qualify' for Compression

By VoldemarG

Does anyone know of any existing script that would allow me to list all...

Basic SQL Question

By porterdl

I am new to SQL and I am having a hard time finding resources...

Delet old backup in azure

By abdalah.mehdoini

Hello, How to delete backups in blob storage from azure sql server VM to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers