Jeff Smith

Jeff has worked in various programming and analyst roles over the past 10 years, ranging from report writer to systems analyst to database architect to web developer, the common thread being working with SQL Server. He holds a degree in Computer Science from the University of Massachusetts and currently resides in Brookline, Massachusetts.

Articles

Using SET NULL and SET DEFAULT with Foreign Key Constraints (12 August 2008)

Implementing Table Interfaces (19 May 2008)

Implementing Table Inheritance in SQL Server (20 February 2008)

Aggregating Correlated Sub-Queries (23 October 2007)

Working with Time Spans and Durations in SQL Server (15 October 2007)

How to Use GROUP BY with Distinct Aggregates and Derived tables (31 July 2007)

How to Use GROUP BY in SQL Server (30 July 2007)

Returning Complex Data from User-Defined Functions with CROSS APPLY (11 June 2007)

SQL Server 2005: Using OVER() with Aggregate Functions (21 May 2007)

Use SqlBulkCopy to Quickly Load Data from your Client to SQL Server (4 May 2007)

Custom Auto-Generated Sequences with SQL Server (24 April 2007)

Detecting "Runs" or "Streaks" in your data (16 February 2003)

- Advertisement -