Forum Replies Created
Viewing 15 posts - 571 through 585 (of 1,246 total)
-
RE: Trying to speed up this 'GetWorkingDays' function.
Alan.B - Thursday, October 19, 2017 12:43 PMRE: Performance Optimization: Can a varchar(max) be "SPLIT" into 8K chunks at the nearest delimiter AND quickly?
sgmunson - Thursday, October 19, 2017 12:30 PMRE: Trying to speed up this 'GetWorkingDays' function.
sgmunson - Thursday, October 19, 2017 11:38 AMRE: Trying to speed up this 'GetWorkingDays' function.
ChrisM@Work - Thursday, October 19, 2017 9:31 AMRE: Trying to speed up this 'GetWorkingDays' function.
I think I may be on to something here... I need test further before opening my big mouth, but so far...
Single threaded...
With a "MakeParallel" function added to...
RE: Trying to speed up this 'GetWorkingDays' function.
Jeff Moden - Wednesday, October 18, 2017 9:13 PMRE: Trying to speed up this 'GetWorkingDays' function.
Jeff Moden - Wednesday, October 18, 2017 7:08 PMRE: Trying to speed up this 'GetWorkingDays' function.
I have to believe that someone here has the magic go-fast this thing is missing... :crying:
RE: Query Help
I'm not sure why I didn't spot this yesterday, but the fact that, in the SELECT list, you're getting [GLStoreNum] from #tmpX1... and... It wasn't returning any nulls.
That's a big...RE: Query Help
Apply some formatting and thing become easier to see...
SELECT DISTINCT
t.GLStoreNum,
accoutNum = CASE
WHEN gn.GLAcctID = 25 THEN g.GLAcctNum
WHEN gn.GLAcctID...RE: Performance Optimization: Can a varchar(max) be "SPLIT" into 8K chunks at the nearest delimiter AND quickly?
Jeff Moden - Saturday, October 14, 2017 8:57 AMRE: Performance Optimization: Can a varchar(max) be "SPLIT" into 8K chunks at the nearest delimiter AND quickly?
Steve, would something like this work for you? Kinda of "Quirky Splitter"... It decomposed a 335,266 character proc, (the longest text string I that was readily available) start to finish in...
RE: Since looping is bad, how should I accomplish what I am trying to do?
Jeff Moden - Thursday, October 5, 2017 8:41 AM
