Re: Query execution for intervals

From: Tony Rogerson <>
Date: Mon, 6 Feb 2006 15:12:31 -0000
Message-ID: <ds7p06$gk1$1$>

So why say this:

        >>  try putting the end_date into the
        >> PRIMARY KEY to get a covering index

Its about time you started checking your answers, perhaps if you spent a lot less time trying to be clever by putting posters down you might not make so many fundemental mistakes.

Tony Rogerson
SQL Server MVP - free video tutorials

"-CELKO-" <> wrote in message

>>> Can end_date be part of the PRIMARY KEY if it is declared NULL<<
> No, but can put it in a unique index to get coverage.
Received on Mon Feb 06 2006 - 16:12:31 CET

Original text of this message