Carl Federl (6/12/2009)
What you are requesting, a filtered index, is available under SQL Server 2008 but not under 2005 ...
Yeah, thats where I thought this was going too, Carl. But this statement by JK actually means the opposite:
JKSQL (6/12/2009)
yes exactly.there would be one on filter = 0 and then one on filter = 1
Note that IsFilter appears to be a bit column (or used as a boolean), so 0 and 1 cover all of its possible values.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]