Ok, that makes it...

There's no gap in the one I just posted. That's why I'm asking if that one qualifies or not.

Yeah, I meant football...

Ok. What about this, would this one qualify or not?

Insert Into ClientEnrollment (ClientID, eff_dt, exp_dt) Values (4, '2008/01/01', '2009/01/01')

Insert Into ClientEnrollment (ClientID, eff_dt, exp_dt) Values (4, '2009/01/01', '2010/01/01')

or does the...

RBarryYoung (6/15/2009)

---

GilaMonster (6/15/2009)...No one I've spoken with knows exactly where the estimate is coming from. It's not the 30% of the table that's used with inequalities when a estimate can't...

And the expected results from that sample data?

Please can you take a read through the article I referenced?

Grant Fritchey (6/15/2009)

---

I seriously doubt it'll be the US, but I always hold on to the hope....

I thought Rockies were mountains.

Any thoughts on who's going to take the FIFA Confederations Cup this year?

Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

jpalmer (6/15/2009)

---

I was treating the SP variables like ASP variables - didn't know that my "custom" variable had to be "DECLARE"ed instead of just listing it at the top...

ps (6/15/2009)

---

model - this is the template for new databases, if you're making any change to this template, you should back it up. This also stores job histories, including backup/restore...

Do the update stats before the rebuild/reorg. Reason is that an index rebuild will update stats will full scan, so if you do a sampled update after that you end...

Personally I'd just back the system databases up once a week and leave it at that.

Ewald Cress (6/14/2009)

---

Gail, this is a shot in the dark, but have a look at the relationship between the actual (17134) and estimate (5623). This is roughly 30%, which corresponds...