Steve Jones - SSC Editor (3/17/2011)

---

Congrats, I need to take those exams....

Stefan Krzywicki (3/17/2011)

---

Roy Ernest (3/17/2011)

---

Congrats Chad... happy for you... 🙂

Now would you...

Wahoo! Just passed 70-454. I am now officially SQL 2008 DBD ITP. 😀 Yipee!

jcrawf02 (3/10/2011)

---

We actually have annual contests to see who can guess the most acronyms, and we pass out a list to new hires so they're not completely clueless. Has over...

Yes, I've noticed that. I'm not sure what "industry" does, but I'm guessing that frequently after doing the swap, you move the archive data to another database or to...

hooo boy. :sick:

I guess that's what code review is for, I think you nailed it. Thanks!

Thanks,

Chad

Thanks Stefan and Jan, I appreciate your replies.

Stefan - I'll run the query against sys.partitions tonight - I left the laptop at home today (bad move), so I don't have...

Sorry to plug my own thread, but does anyone have table partitioning experience that could shed light on odd behavior?

Thread: $PARTITION function wrong after switch?

This isn't production (just research) so...

If there are no ideas, can anyone repo it (and does it look odd to you too)?

I admit this is on a vanilla (unupdated) SQL2K8 Eval edition, so I wouldn't...

jcrawf02 (1/18/2011)

---

Chad Crawford (1/18/2011)

---

That is correct.

The easiest way I've found to explain it is to figure out how you can lose. There are three choices, right?

If you've picked...

Stefan Krzywicki (1/18/2011)

---

Chad Crawford (1/18/2011)

---

jcrawf02 (1/18/2011)

---

Not sure I'm following the paradox of the free range chicken. Are you saying it's a paradox because they no longer roam the great...

jcrawf02 (1/18/2011)

---

Not sure I'm following the paradox of the free range chicken. Are you saying it's a paradox because they no longer roam the great plains in vast flocks, covering...

Thank you for the generous offer! My BS is in statistics so I cringe a little when I hear that quote, but I have to admit that even statisticians...

sqlbuddy123 (1/10/2011)

---

That's correct and Gail gave a good explanation as always.

...

Thanks Gail. I appreciate the sanity check and the clarification. I think that the index and statistics maintenance often go hand-in-hand and that's where the idea to do...