February 15, 2011 at 6:24 am
Dave Ballantyne (2/15/2011)
Big meeting on friday to best decide how to handover all my knowledge to co-workers.First big change i need to do today is was told to make the change and we'll do the handover later.
This is a big C++ app , no-one else even knows C++, and is mission critical :crying:
11 weeks and counting....
That almost sounds like it should be in the dictionary definition of SNAFU.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 15, 2011 at 6:25 am
Roy Ernest (2/15/2011)
Dave Ballantyne (2/15/2011)
Big meeting on friday to best decide how to handover all my knowledge to co-workers.First big change i need to do today is was told to make the change and we'll do the handover later.
This is a big C++ app , no-one else even knows C++, and is mission critical :crying:
11 weeks and counting....
You are leaving soon and they want you to change the application no one else can fix? They should be glad that you are a nice guy... 😀
Indeed. Time to ask for a big raise for those 11 weeks!
What can they do? Fire you? 🙂
(unless you want to walk out with a good reputation of course)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 15, 2011 at 11:08 am
Dave Ballantyne (2/15/2011)
Big meeting on friday to best decide how to handover all my knowledge to co-workers.First big change i need to do today is was told to make the change and we'll do the handover later.
This is a big C++ app , no-one else even knows C++, and is mission critical :crying:
11 weeks and counting....
Are you going to start a consulting job?
If so, I guess I know one of your first customers you'll establish a long term relationship with... 😀
February 15, 2011 at 3:14 pm
LutzM (2/15/2011)
Dave Ballantyne (2/15/2011)
Big meeting on friday to best decide how to handover all my knowledge to co-workers.First big change i need to do today is was told to make the change and we'll do the handover later.
This is a big C++ app , no-one else even knows C++, and is mission critical :crying:
11 weeks and counting....
Are you going to start a consulting job?
If so, I guess I know one of your first customers you'll establish a long term relationship with... 😀
"So, after Dave left the company and became a consultant, what's the difference?"
"About $85 per hour..."
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 15, 2011 at 8:03 pm
Can anyone point me to a delimited split function that works on a varchar(max)? I know that Jeff's DelimitedSplit8K works on up to a varchar(8000), and I seem to recall that there were performance issues going beyond that.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
February 15, 2011 at 8:15 pm
Have you searched the threads here on ssc? IIRC one was started by Lutz and there may be a solution somewhere there. Unfortunately, I don't remember the title of it.
February 15, 2011 at 10:18 pm
WayneS (2/15/2011)
Can anyone point me to a delimited split function that works on a varchar(max)? I know that Jeff's DelimitedSplit8K works on up to a varchar(8000), and I seem to recall that there were performance issues going beyond that.
Well, at great risk of embarrassing myself in front of some big names with my initial post on this thread, this is what I've got:
create function dbo.fn_SplitString
(
-- Add the parameters for the function here
@StringToSplitvarchar(max)
, @Delimitervarchar(max)
)
returns
@retSplitString table
(
-- Add the column definitions for the table variable here
RowNumintidentity(0,1)
, Valuevarchar(max)
)
as
begin
declare@DelLenint;
select@DelLen = len(@Delimiter)
, @StringToSplit = @Delimiter + @StringToSplit + @Delimiter;
insert into @retSplitString
selectsubstring(@StringToSplit, dd.ID + @DelLen, charindex(@Delimiter, @StringToSplit, dd.ID + @DelLen) - dd.ID - @DelLen)
from<tally table> dd
wheredd.ID < (len(@StringToSplit)-@DelLen*2+2)
and substring(@StringToSplit, dd.ID , @DelLen) = @Delimiter;
return
end
go
The more astute readers will no doubt recognize the basic algorithm. 🙂 I'd also point out that I've not mad much chance to run many MAX strings through it, so if you discover any, erm, shortcomings, then please PM me. As to performance, I can split a 90,000 char string within half a second. I would also mention that the number of rows returned is limited by the number of rows in your tally table.
S.
February 15, 2011 at 11:12 pm
Fal (2/15/2011)
WayneS (2/15/2011)
Can anyone point me to a delimited split function that works on a varchar(max)? I know that Jeff's DelimitedSplit8K works on up to a varchar(8000), and I seem to recall that there were performance issues going beyond that.Well, at great risk of embarrassing myself in front of some big names with my initial post on this thread, this is what I've got:
...
Is that ... SQL code? In THE thread? :ermm: :blink:
😀
On a related notice, does anyone know how a CLR function using the .NET Split() function would perform?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 15, 2011 at 11:30 pm
You got your code in my THREAD! ARGGGHHH... We need to take this outside!
I believe, if memory serves, there was an algorithm for using XML instead of the standard method for VARCHAR(MAX) that Jeff was going back and forth with someone regarding, and it seemed to up the speed for the MAX level. Note, my memory is poor but I do vaguely remember a bunch of benchmarking going on somewhere in the forum somewhere...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 16, 2011 at 5:31 am
Well, since someone broke the "no technical talk in The Thread" rule...
Guess what I discovered this morning? Severity 21 errors can be caused by full disk drives. Nothing's actually wrong with the disk. Well, except for the fact that it's so full, my database files can't grow.
grumblemumblecurse.
February 16, 2011 at 6:45 am
Koen Verbeeck (2/15/2011)
Fal (2/15/2011)
WayneS (2/15/2011)
Can anyone point me to a delimited split function that works on a varchar(max)? I know that Jeff's DelimitedSplit8K works on up to a varchar(8000), and I seem to recall that there were performance issues going beyond that.Well, at great risk of embarrassing myself in front of some big names with my initial post on this thread, this is what I've got:
...
Is that ... SQL code? In THE thread?
Uh oh...
Craig Farrell (2/15/2011)
You got your code in my THREAD! ARGGGHHH... We need to take this outside!
Oh no...
Brandie Tarvin (2/16/2011)
Well, since someone broke the "no technical talk in The Thread" rule...
D'OH!
I knew I should've lurked longer. But no, I had to help someone! 😛
Steve.
February 16, 2011 at 6:50 am
Fal (2/16/2011)
D'OH!I knew I should've lurked longer. But no, I had to help someone! 😛
Steve.
Aw. It's okay. We won't tar and feather you for being helpful and posting code...
...not in public anyway. But I'd avoid dark alleys, if I were you. Especially dark alleys near SQL Saturdays and PASS events. 😀
February 16, 2011 at 6:54 am
WayneS (2/15/2011)
Can anyone point me to a delimited split function that works on a varchar(max)? I know that Jeff's DelimitedSplit8K works on up to a varchar(8000), and I seem to recall that there were performance issues going beyond that.
I've got a new splitter I've been working on for the revision of the Tally Table article. It absolutely screams on 8k even compared to the old DelimitedSplit8K. Since it's bad mojo to post code on the thread, I'll send it to you tonight... I could use a little help testing it. 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
February 16, 2011 at 6:55 am
Craig Farrell (2/15/2011)
I believe, if memory serves, there was an algorithm for using XML instead of the standard method for VARCHAR(MAX) that Jeff was going back and forth with someone regarding, and it seemed to up the speed for the MAX level. Note, my memory is poor but I do vaguely remember a bunch of benchmarking going on somewhere in the forum somewhere...
I did use an XML version based on a previous SSC article as it didn't need another resource, but it fell on it's face at the first ampersand (&). I couldn't see a way of making the string XML-safe without blowing away performance, so I turned back to tally table.
If you like, I can post the code for it?? 😀
Steve.
February 16, 2011 at 7:28 am
Fal (2/16/2011)
Koen Verbeeck (2/15/2011)
Fal (2/15/2011)
WayneS (2/15/2011)
Can anyone point me to a delimited split function that works on a varchar(max)? I know that Jeff's DelimitedSplit8K works on up to a varchar(8000), and I seem to recall that there were performance issues going beyond that.Well, at great risk of embarrassing myself in front of some big names with my initial post on this thread, this is what I've got:
...
Is that ... SQL code? In THE thread?
Uh oh...
Craig Farrell (2/15/2011)
You got your code in my THREAD! ARGGGHHH... We need to take this outside!Oh no...
Brandie Tarvin (2/16/2011)
Well, since someone broke the "no technical talk in The Thread" rule...D'OH!
I knew I should've lurked longer. But no, I had to help someone! 😛
Steve.
I blame Wayne. Execution at noon.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 15 posts - 24,016 through 24,030 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply