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

2003-02-20

12,786 reads

Discuss

Blogs

Trusting the Fine Print or connecting Azure Data Factory with Salesforce

By Rayis Imayev

(2022-Jan-19) David Eldersveld once said that a “cool solution is a completely insecure solution” -...

Creating a new User-Defined Data Type–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for...

A new chapter begins

By Randolph West

In 2012 when I originally founded Born SQL, I never imagined I would find...

Read the latest Blogs

Forums

when execute query it take 32 second to return 2 rows so how to solve slowly iss

By ahmed_elbarbary.2010

I work on sql server 2017 i face issue when run simple query it...

Recursive Triggers

I know there is, somewhere, T-SQL that will allow me to update (keep in...

How to get cummulative sum per column?

By Barendrecht82

Hi, I have a statement per period. I want the periods to be cumulate. ...

Visit the forum

Question of the Day

Endpoint Authentication Order

See possible answers