Matt... is that going to work in 2k?

Grant Fritchey (2/13/2008)

---

Jeff,

Doesn't the fact that floats are imprecise estimates represent a pretty major possible problem in using them in financial calculations? At least that's what I've always been told....

Ian Crandell (1/9/2008)

---

Jeff Moden (1/8/2008)

---

We've actually put some "documentation standards" into play at work. They're not so limiting as to suppress innovation, but they do state what must be...

Heh... one of the many reasons I don't use DTS...

I've used Money... I've used SmallMoney... I've even used Decimal... and they all failed the accuracy test when it came to things like mortgage calculations.

If all you're ever going to...

Yes... it does make a difference... about 21% without an order by and about 12% with an order by. But wait...

Heh... on a million rows of data with...

Just curious... which way did you end up going exactly?

stricknyn (2/12/2008)

---

Hello,

Seems like this should be pretty straight forward, but its not working. I'm trying to build a string with 7 characters from a random statement:

Declare @mn int

Declare @mx...

I'm confused... I believe the cross-join is to generate a million rows... not to generate the 7 digits. Perhaps I was looking at the wrong post. Which one...

Michael Valentine Jones (2/12/2008)

---

John Beggs (2/12/2008)

---

I think you'll find that the difference between 1ms and 1ms is pretty negligible. Feel free to test for yourself.

What boundary would you set...

Heh... proof again... performance is in the code... water cooled CPU's wouldn't have made that query run any faster.

Nice job, Matt.

Previews lie... not sure I'd take 100% stock in the preview any more than the trust I put in an estimated execution plan (which I don't trust at all ;)...

Heh... correct... there's always that "one time" that justifies the cold water you have running through the garden hose to baseplate of the CPU in your server 😉

Crud... I've been there and done that... having a boss that wears a big ol' chip on his shoulder...

Sure...

Heh... perfect...