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

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)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email:

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

SQL Server Jobs

Resources

SQL Server Resources

Advertise on SQLTeam.com

SQL Server Books

SQLTeam.com Newsletter

Write for SQLTeam.com

Contact Us

About the Site