Viewing 15 posts - 11,716 through 11,730 (of 18,923 total)
So they think they overthrow data modeling standards???
I wouldn't like to be in your position right now... I hope this is the only sample of this problem you'll find...
September 21, 2006 at 7:19 am
Nice to learn that... and I would expect it to perform slightly better than my version
.
September 20, 2006 at 1:40 pm
I don't know if this is acceptable performance wise in your case but it prints total on the last line ![]()
Select
...
September 20, 2006 at 1:30 pm
You can do sum(sum))
You need to put the first sum in a derived table, and then redo another sum on that.
September 20, 2006 at 1:24 pm
Well I'm out of ideas. Please tell us when you find something.
September 20, 2006 at 9:01 am
Very interesting question... can you tell us what the function is doing?
I could understand a very small difference but 10 times faster!!
September 20, 2006 at 8:37 am
There's a way to do it but why do you want to do it? Do you have an obligation to have that number in sequential order or you just think...
September 20, 2006 at 8:35 am
too much coffee this morning ?? ![]()
September 20, 2006 at 8:18 am
As far as I understand, the Bin value doesn't need to be returned. It needs to be converted to HEX, nothing more, nothing less.
September 20, 2006 at 8:08 am
Ya and at least 3-4 other small threads of a few messages.
September 20, 2006 at 7:24 am
I don't know about the tuning advisor, but in query analyser, if you show the execution plan, then the trigger's plan will be included as well.
However I'd also look at...
September 20, 2006 at 7:22 am
Why the heck does he have access to the PRODUCTION TABLES ![]()
![]()
?
September 20, 2006 at 7:01 am
Just curious. Can you run both version (even on another server) and tell us which one is the fastest?
September 20, 2006 at 6:54 am
Viewing 15 posts - 11,716 through 11,730 (of 18,923 total)