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,154 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

Life Support 2008 – Audit Logons

By

Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep...

All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT

By

This is the first in a series of posts about gatekeeping in Information Technology...

Read the latest Blogs

Forums

SQL Query Assistance Required

By troy1w1w

Hi. I am wanting to know if there is a way to make this...

Stairway to Database Containers Level 3: Building Custom Container Images by Hand

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Stairway to Database Containers Level...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers