Peter Heller (3/29/2015)

---

Compliments on your article.

If you defined the EffectiveEndDT as DiscontinuedDT your queries would not have to use Isnull. It would be sargable and make the query optimizer a little happier :-).

Also, I always try avoid defining tables with dbo, I prefer to create a schema which in fact may be owned by dbo for a set of grouped SQL objects.

[p]

--

-- Setting a default value for Maximum EffectiveEndDT

--

EffectiveEndDT DATETIME NOT NULL DEFAULT ('2099-12-31')

DiscontinuedDT DATETIME NOT NULL DEFAULT ('2099-12-31')

DECLARE @GetPriceOn DATETIME = '2013-12-31';

--

-- EffectiveEndDT set default value '2099-12-31'

--

-- sargable

--

SELECT ProductID, EffectiveStartDT, EffectiveEndDT, ProductPrice

FROM dbo.ProductPrices

WHERE @GetPriceOn >= EffectiveStartDT AND @GetPriceOn < EffectiveEndDT;

[/p]

Thank you for sharing this article.