Viewing 15 posts - 346 through 360 (of 727 total)
I'm going to assume that you didn't attach any system databases to this server in the last few days, but if you did, that's often a cause of this sort...
June 10, 2007 at 9:39 pm
You provided two different sets of source numbers, one truncated, the other untruncated.
Untruncated numbers of .0050 through .0059 were all represented by the truncated number .0050 in your data....
June 10, 2007 at 9:30 pm
Since this thread is so long, I think it's about time for a recap for those joining us late. Sergiy will be identified as "Giordy" for this purpose, while everyone...
June 10, 2007 at 7:40 pm
I ran your numbers, just like I ran your numbers before (hell, it was entirely your test last time), and have continually showed that BR does a better job in...
June 10, 2007 at 7:20 pm
In addition to what SHNK said, it can depend on how your product is licensed. Here (warning: .doc file) is the official word, and if you want more info,...
June 10, 2007 at 6:20 pm
Archiving means many things to many people, and could mean everything from backups stored in an offsite location, to partitioned views, or even something as simple as a history table...
June 10, 2007 at 5:44 pm
It sounds like you're going to need an offset self-join (or some potentially nasty subqueries) , to go with your left outer join, but I'm with mrpolecat in that we need...
June 10, 2007 at 5:41 pm
To be nice to you, I went ahead and did the averages for you, using your dataset. Unfortunately, they show the exact same thing.
Averages:
Original Truncated Number: .9995
Traditionally Rounded Truncated Number:...
June 10, 2007 at 5:36 pm
Once again, I ran your numbers. I just showed the actual results, not the difference between rounding two different numbers. Why in the world would you consider a rounding function...
June 10, 2007 at 4:44 pm
You truncated the results (yes, I caught your little extra parameter) and then compared rounded versions of a truncated number (@B) with a rounded versions of a non-truncated number (@A), calling those...
June 10, 2007 at 11:33 am
Which part of the statement: "The only criteria is that it include a large, randomly distributed data sample set, and that it demonstrates that traditional bias has less (or even...
June 10, 2007 at 1:11 am
Of course I do, as does everyone else in this thread, save for you. A result can absolutely be precise even if there is precision specified. You might be be...
June 9, 2007 at 11:17 am
When in the world did I ever say there are no "precise" numbers? There are "precise" numbers, using many of the different definitions of "precise", including mathematical definitions. You are...
June 8, 2007 at 9:52 pm
I would check the owner of TestTable, and make sure it is dbo.
June 8, 2007 at 9:44 pm
Viewing 15 posts - 346 through 360 (of 727 total)