SQL Server Integration Services (SSIS) includes two very interesting transforms, the Fuzzy Grouping and Fuzzy Lookup transformations. Brian Norberg discussed the former in another article and this time examines the Fuzzy Lookup Transformation.
2007-07-19
9,975 reads
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.
2007-07-16
8,267 reads
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
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By nelsonaloor
Introduction: In this article, we will discuss the MS SQL Server database corruption. So, first, we...
I have held various certifications through my DBA career, from CompTIA A+ certification back...
Hi, The application team is pushing more than 7 lakhs records per day to...
I'm trying to develop a formula to convert minutes (my raw data) to hh:mm:ss...
I've been querying sys.dm_db_index_usage_stats on the nodes of an availability group, and I've noticed...
Ask SSC