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

12,967 reads

Discuss

Blogs

Parameter Sensitive Plan Optimization in SQL Server 2022. What is it and is it any good?

By Matthew McGiffen

Parameter Sensitive Plan (PSP) optimization is a new feature in SQL Server 2022 that...

Azure chaos STUDIO

Chaos engineering is fun but especially important when building solutions in the cloud. It...

Announcing a New Book on SQL from 3Cloud Authors

By DataOnWheels

I am proud to announce the launch of a new book, centered around the...

Read the latest Blogs

Forums

Azure DW default schema in a query / proc equal to "Search_Path" in AWS

I know you can't do this in MSSQL, but hoping DW has progressed more....

Call SQL Agent job using different account to one executing powershell

Hi Folks trying the below but having zero luck and was wondering if anybody...

Encrypt Varchar(max) column in SQL Server

I have a varchar(max) column which has sensitive data and want to encrypt it....

Visit the forum

Question of the Day

Max Managed Instance CPUs

See possible answers