Brian Nordberg

  • Interests: Hiking, Biking, Canoeing, database stuff

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2007-07-16

8,368 reads

Technical Article

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

You rated this post out of 5. Change rating

2002-10-03

223 reads

Blogs

A New Word: Ghough

By

ghough – n. a hollow place in your psyche that can never be filled;...

T-SQL Tuesday: Encryption and Data Protection

By

I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...

Parameterize your Databricks notebooks with widgets

By

Widgets provide a way to parameterize notebooks in Databricks. If you need to call...

Read the latest Blogs

Forums

Need help on query within 2 column, generate another column

By Adelia

Hi, This is my table and data CREATE TABLE [dbo].[rpt_AR_StatementOfAcct_100]( [Id] [int] IDENTITY(1,1) NOT...

SELECT blocking DML and DDL

By vsamantha35

Hi All. I am seeing a scenario where SELECT is blocking a TRUNCATE statement...

query filling up tempdb

By vsamantha35

Hi All, Need some help in tune a function which is reading TB's of...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers