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
http://sqlserverfaq.com - free video tutorials
"-CELKO-" <jcelko212_at_earthlink.net> wrote in message
news:1139233708.664866.93410_at_g47g2000cwa.googlegroups.com...
>>> 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 - 09:12:31 CST
