Brian Nordberg

  • Interests: Hiking, Biking, Canoeing, database stuff

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

221 reads

Blogs

Azure SQL Managed Instance Versions

By

Just a really quick FYI for the readers. If you are using Managed Instances...

A summary of new features in Azure SQL Database

By

It has been some time since I last wrote about Azure SQL Database. Although...

Daily Coping 23 Jun 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

about the concern about sp_updatestats

By 892717952

Do I still need to run sp_updatestats  if I execute DBCC DBREINDEX(tablename) for tables...

SQL Server 2019 Distributed Availability Groups

By DK

Hello.  I am looking into setting up a Distributed Availability Group between 2 availability...

Server Roles and Permissions

By Atat Rowcount

Hi guys Setting up a new SQL Server on Azure (Managed Instance).  I have...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers