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 (1)

Log in or register to rate

You rated this post out of 5. Change rating

2003-02-20

13,156 reads

Discuss

Blogs

My 2024 in Data: Music

This is my last week of the year working (I guess I come back...

A New Word: Suente

suente– n. the state of being so familiar with someone that you can be...

Side Projects

By Andrew Pruski

Anyone (everyone?) who has ever tried to learn a programming language knows that to...

Read the latest Blogs

Forums

Timeout Error while executing a TSQL statement in Sql server Express Edition

By IT researcher

I am getting the below error when I execute a SQL command in SQL...

Timeout Error while executing a TSQL statement in Sql server Express Edition

By IT researcher

I am getting the below error when I execute a SQL command in SQL...

Sql script replace and rearrange numbers

By diegodeveloper

Hi everyone. I have this table and this information. (left side of the image)...

Visit the forum

Question of the Day

DCL

We have DDL, DML, and DCL. What is DCL used for?

See possible answers