Viewing 15 posts - 44,956 through 44,970 (of 59,063 total)
Very cool... lot's of folks take that suggestion the wrong way or kicking and screaming. 😛 You took it absolutely the correct way. Thanks for the feedback,...
February 24, 2009 at 8:16 pm
Ashwin M N (2/24/2009)
February 24, 2009 at 8:10 pm
pezhman123 (2/23/2009)
first :
let me inform you that I got the error below while trying to
run your code please let me know what is the problem.
Msg 492, Level...
February 24, 2009 at 7:29 pm
If memory serves correctly, the outer cylinders of a disk actually have more sectors of data than the inner cylinders simply because there's more real-estate. Even the old "windsor"...
February 24, 2009 at 6:41 pm
Andrew (2/23/2009)
Lesson learned (while refactoring) was same as VB et al code - break 1 big in to parent with lots of smaller sections.
When...
February 24, 2009 at 6:21 pm
norbertackerman (2/24/2009)
Jeff and Matt,Thank you both for your help!
The data is quite small. Only a few thousand rows. No real perfomance issues. The previous version works perfectly!
Norbert
You're welcome, but... saying...
February 24, 2009 at 6:13 pm
Ah... almost forgot... you still haven't told me what the clustered index on the table is.
February 24, 2009 at 6:18 am
I take a swing at it after work tonight.
February 24, 2009 at 6:18 am
In full recovery mode, as with I/O, I don't believe it's the number of rows that actually matters... it's the byte count.
For I/O, using aggregation, like SUM, for...
February 23, 2009 at 8:46 pm
Absolutely... it supposedly allows the re-use of execution plans for a multiple "hit" environment such as that which a GUI with lot's of users my provide.
In a batch environment, it...
February 23, 2009 at 7:53 pm
Nice chunk of test generation code, Bob. Well done and thanks of posting it.
Yeah, if ya just gotta do some concatenation, I very much like the FOR XML...
February 23, 2009 at 6:49 pm
Heh... I agree... the code is way to long, way too slow, and way too poorly written. The code does accounts receivable for 1.5 million customers on a daily...
February 23, 2009 at 6:44 pm
The only time I use sp_execute, is if the dynamic SQL needs to put a value in a return variable. Since that's normally done only for GUI code, I...
February 23, 2009 at 6:08 pm
Adam Machanic (2/23/2009)
February 23, 2009 at 4:57 pm
Sooooo.... Sriram.... your question has people using the "C" word. Can we please hear back from you as to why you want to do this? Not looking to...
February 23, 2009 at 4:36 pm
Viewing 15 posts - 44,956 through 44,970 (of 59,063 total)