David Sumlin

David Sumlin has run his own contracting business for the last 6 years and has been involved in SQL development for the last 8 years. He and his team of skilled developers have tried to stay up to date with Microsoft development technologies when it comes to SQL and .net. For the last few years, HeadWorks Inc. has been focused on data warehouses and marts and the reporting applications that interact with them for large financial institutions. When David isn't coding, he's out looking for birdies!

A Lookup Strategy Defined

by David Sumlin

SQLServerCentral.com

Basics

Most databases designs nowadays seem to have at least a few if not many lookup or reference tables. This article helps you define a strategy in how to design, approve, and deploy them.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

Log in or register to rate

You rated this post out of 5. Change rating

2003-02-20

13,229 reads

Discuss

Blogs

Self-Hosting a Photo Server the Whole Family Can Use

Until recently, my family's 90,000+ photos have been hidden away in the depths of...

Start with the FabricTools PowerShell module

Managing Microsoft Fabric at scale quickly becomes painful if you rely only on the...

Enterprise AI Operating Rhythm – Top 5 practices for 2026

By Joyful-Craftsmen

2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...

Read the latest Blogs

Forums

Celebrating Tomorrow

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Celebrating Tomorrow

SQL Art: I Made a Christmas Card In SSMS

Comments posted to this topic are about the item SQL Art: I Made a...

lookup error

By [email protected]

I am using ssrs in visual studio 2022, I work on a report, there...

Visit the forum

Question of the Day

Celebrating Tomorrow

Which of these is more appropriate for tomorrow?

See possible answers