simulate: “file Streams into Memory, then JOIN the data in Memory, via LINQ to Objects” original article: http://blogs.claritycon.com... I wrote up a quick little WinForms project in VS2008 with .NET Framework 3.5, Code overview: 1. On Form_Load, a. create a List of People into DataDridView and in Memory b. create a List of Jobs into DataDridView and in Memory c. create a List of JobIds into ComboBox 2. On ComboBox_SelectedIndexChanged, a. Perform LINQ...

List All Primary Keys and Foreign Keys Original article: http://www.sqlteam.com/foru... set nocount on create table #PK(constraint_schema sysname not null, constraint_name sysname not null, sql varchar(4000) not null, constraint PK_#PK primary key clustered(constraint_schema, constraint_name)) create table #cols(constraint_schema sysname not null, constraint_name sysname not null, column_name sysname not null, ordinal_position int not null, constraint PK_#PKcol primary key...