Fuzzy Lookup and Fuzzy Grouping in SQL Server Integration Services 2005

This paper describes the Fuzzy Lookup and Fuzzy Grouping transformations that are part of SQL Server 2005 Integration Services (SSIS). These SSIS transformations are useful for improving the data quality of existing data as well as new data that is being loaded into your database.

Internals of DBM Failover / Role Switching

Understanding different types of failovers/Role Switching and How do they internally work in database mirroring.

Employ Metadata to Enhance Search Filters

Discover how to use metadata for pooling information already resident in an application to create a flexible search interface that reduces complexity and increases users' productivity.

Measures

Monitoring Stored Procedure Performance with sys.dm_exec_cached_plans

This article will show you how to use the sys.dm_exec_cached_plans DMV to monitor the performance of stored procedures

Data Generator Source Adapter

The Data Generator Source is now available for SQL Server 2005 and SQL Server 2008. This component needs little explanation. It generates random integer (DT_I4) and string (DT_WSTR) data and places them in the pipeline.

Implementing Table Inheritance in SQL Server

When designing a database, we sometimes come across situations where there are multiple types of entities that we are modeling, but we'd like them to all have certain attributes or relations in common. Using "sub-type" tables is a simple way to implement table inheritance in SQL Server.

Precedence

Schema Comparison with Visual Studio Team Edition for Database Professionals

In this article Dinesh Priyankara describes how schema comparison can be performed using Visual Studio Team Edition for Database Professionals.

Statistics and Indexes

When is it okay to let SQL Server to make a statistic for columns in your queries, and when should you take those statistics and make an index out of them? What I do is to test all of my procs, and if they generate system statistics (_WA_SYS%), then I add an index to the table for the column in the statistic. But is this a good practice?