There you go. Why do you think...

Michael Valentine Jones (8/23/2011)

---

paul_ramster (8/23/2011)

---

That's the same algorithm I posted further up the thread, although rather better explained.

The only assumption that is made is that you know a Monday, which...

Especially at PASS :-D.

Grant Fritchey (8/23/2011)

---

That's a great idea! Maybe...

Same train of thoughts but with triggers. I wrote this 4 years ago but it still apply to this case => http://www.simple-talk.com/sql/t-sql-programming/rbar--row-by-agonizing-row/

Awesome info.

You guys should really get together and write books or talk @ PASS sometimes :hehe:.

Now what could you possibly talk about? :Whistling:

That's especially why I commended you on thinking on your feet.

From us (regular posters), we know the avg level on knowledge of people coming here for help (and the state...

5M rows is not much. Should run pretty fast if you can avoid that function...

I'm glad to see that I'm not the only one having 2nd thoughts about this one.

Don't get me wrong I love the ingenuity behind the idea. But the fact...

It's executed one per row. Hence 86K times.

The reason it "becomes" slow is that 86K times 0.01 sec is still 8.6 seconds.

Grant Fritchey (8/22/2011)

---

Ninja's_RGR'us (8/22/2011)

---

nawillia (8/22/2011)

---

i believe brent ozar also mentions this in his performance tuning for race car drivers video. he mentions the overlapping stats and some other good stuff....

nawillia (8/22/2011)

---

i believe brent ozar also mentions this in his performance tuning for race car drivers video. he mentions the overlapping stats and some other good stuff. (but not...

skrilla99 (8/22/2011)

---

Assuming it is supported, is there any glaring reason not to do it?

Code base for Eval should be the same as full release, right? With just a license...

Less than 20% actually.

80% of that number on tables with no data. So no real rush :w00t:.

If you want to destroy your server, a shotgun approach is much faster and cheaper. Especially more fun.

Last time I say this, read the articles we linked to.