February 17, 2011 at 6:57 am
The Dixie Flatline (2/17/2011)
Jeff Moden (2/16/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.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. 😛
Hey Jeff, could I have a peek?
P.S. My mind was in the gutter too.
Heh... the list is growing by leaps and bounds. Lot's of folks sent me the same request via email (thank goodness my PM box is full! :-D). Maybe I should just start a thread on it. I've still got some code to write so that everyone can run the same tests.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 17, 2011 at 7:00 am
Brandie Tarvin (2/17/2011)
Koen Verbeeck (2/17/2011)
Gianluca Sartori (2/17/2011)
Code brings more (pseudo)code, it seems...Definitely kill the one who started this on THE THREAD!
:-D:-D
I'll go fetch the angry mob! 🙂
I'll supply the torches! (Who's responsible for the pitchforks?)
Grant has a titanium spork he's inordinately proud of, maybe we can borrow that?
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
February 17, 2011 at 7:07 am
jcrawf02 (2/17/2011)
Brandie Tarvin (2/17/2011)
Koen Verbeeck (2/17/2011)
Gianluca Sartori (2/17/2011)
Code brings more (pseudo)code, it seems...Definitely kill the one who started this on THE THREAD!
:-D:-D
I'll go fetch the angry mob! 🙂
I'll supply the torches! (Who's responsible for the pitchforks?)
Grant has a titanium spork he's inordinately proud of, maybe we can borrow that?
Word is I may soon have two of those, so we're on our way. 2 or more for a mob right?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 17, 2011 at 7:20 am
Grant Fritchey (2/17/2011)
jcrawf02 (2/17/2011)
Brandie Tarvin (2/17/2011)
Koen Verbeeck (2/17/2011)
Gianluca Sartori (2/17/2011)
Code brings more (pseudo)code, it seems...Definitely kill the one who started this on THE THREAD!
:-D:-D
I'll go fetch the angry mob! 🙂
I'll supply the torches! (Who's responsible for the pitchforks?)
Grant has a titanium spork he's inordinately proud of, maybe we can borrow that?
Word is I may soon have two of those, so we're on our way. 2 or more for a mob right?
So, if you use the UK definition of torches to mean flashlights, our mob will be carrying around mini-mags and titanium sporks.
Oh, yeah. We're dangerous. @=)
EDIT: GAH. I wish I were an artist. I need someone to draw a picture of geeks standing threateningly with their mini-mags and sporks. I can't get that image out of my head.
February 17, 2011 at 7:21 am
george sibbald (2/17/2011)
Koen Verbeeck (2/16/2011)
Jeff Moden (2/16/2011)
CirquedeSQLeil (2/16/2011)
For the execution of Wayne:
--get spid of code requestor
sp_whorequestedcodeIntheThread 'Wayne'
--use returned spids to verify the request
dbcc inputbuffer(61)
--output
'Wayne definitely requested code on the thread'
--yup that's the one
Kill 'Wayne'
just one bad underscore in the name of that sp could change its meaning entirely. 😛
Great, I'm glad I'm not the only one with a dirty mind 😀
when I saw it my FIRST thought was 'that should really be prefixed usp_' - what does that say about me?
It says you are behind the times. That procedure is one of the new features in "Denali".
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 17, 2011 at 7:26 am
Jack Corbett (2/17/2011)
george sibbald (2/17/2011)
Koen Verbeeck (2/16/2011)
Jeff Moden (2/16/2011)
CirquedeSQLeil (2/16/2011)
For the execution of Wayne:
--get spid of code requestor
sp_whorequestedcodeIntheThread 'Wayne'
--use returned spids to verify the request
dbcc inputbuffer(61)
--output
'Wayne definitely requested code on the thread'
--yup that's the one
Kill 'Wayne'
just one bad underscore in the name of that sp could change its meaning entirely. 😛
Great, I'm glad I'm not the only one with a dirty mind 😀
when I saw it my FIRST thought was 'that should really be prefixed usp_' - what does that say about me?
It says you are behind the times. That procedure is one of the new features in "Denali".
And here I was thinking it was a new feature in "Denial"
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
February 17, 2011 at 7:43 am
Denial.
You've heard the rumors, you've quoted the saying. Now, learn the truth. Is Denial just a river in Egypt? Or is there more to this story than the participants are willing to admit?
Live, here on SQLServerCentral.com at 5:00 your local time, your local channel. Watch, and be amazed...
February 17, 2011 at 7:50 am
Brandie Tarvin (2/17/2011)
Denial.You've heard the rumors, you've quoted the saying. Now, learn the truth. Is Denial just a river in Egypt? Or is there more to this story than the participants are willing to admit?
Live, here on SQLServerCentral.com at 5:00 your local time, your local channel. Watch, and be amazed...
film at eleven...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
February 17, 2011 at 8:16 am
Jeff Moden (2/17/2011)
The Dixie Flatline (2/17/2011)
...My mind was in the gutter too.Heh... the list is growing by leaps and bounds. Lot's of folks sent me the same request via email (thank goodness my PM box is full! :-D). Maybe I should just start a thread on it. I've still got some code to write so that everyone can run the same tests.
I just loved reading this one in a slightly more twisted way ...
- 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 17, 2011 at 10:04 am
and along those lines, am I the only one who can't read anything about HADRON without blinking and re-reading, then chuckling to myself?
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
February 17, 2011 at 10:16 am
jcrawf02 (2/17/2011)
and along those lines, am I the only one who can't read anything about HADRON without blinking and re-reading, then chuckling to myself?
Yep. It's just you.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 17, 2011 at 10:26 am
Grant Fritchey (2/17/2011)
jcrawf02 (2/17/2011)
and along those lines, am I the only one who can't read anything about HADRON without blinking and re-reading, then chuckling to myself?Yep. It's just you.
touche :hehe:
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
February 17, 2011 at 10:32 am
Stefan Krzywicki (2/17/2011)
Jack Corbett (2/17/2011)
george sibbald (2/17/2011)
Koen Verbeeck (2/16/2011)
Jeff Moden (2/16/2011)
CirquedeSQLeil (2/16/2011)
For the execution of Wayne:
--get spid of code requestor
sp_whorequestedcodeIntheThread 'Wayne'
--use returned spids to verify the request
dbcc inputbuffer(61)
--output
'Wayne definitely requested code on the thread'
--yup that's the one
Kill 'Wayne'
just one bad underscore in the name of that sp could change its meaning entirely. 😛
Great, I'm glad I'm not the only one with a dirty mind 😀
when I saw it my FIRST thought was 'that should really be prefixed usp_' - what does that say about me?
It says you are behind the times. That procedure is one of the new features in "Denali".
And here I was thinking it was a new feature in "Denial"
I really considered rewriting that name of that proc to camelcase it - but wanted to let it roll and see who would say something about it. Looks like a bunch made a Ken Jennings type of "rake" mistake.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 17, 2011 at 11:35 am
CirquedeSQLeil (2/17/2011)
Stefan Krzywicki (2/17/2011)
Jack Corbett (2/17/2011)
george sibbald (2/17/2011)
Koen Verbeeck (2/16/2011)
Jeff Moden (2/16/2011)
CirquedeSQLeil (2/16/2011)
For the execution of Wayne:
--get spid of code requestor
sp_whorequestedcodeIntheThread 'Wayne'
--use returned spids to verify the request
dbcc inputbuffer(61)
--output
'Wayne definitely requested code on the thread'
--yup that's the one
Kill 'Wayne'
just one bad underscore in the name of that sp could change its meaning entirely. 😛
Great, I'm glad I'm not the only one with a dirty mind 😀
when I saw it my FIRST thought was 'that should really be prefixed usp_' - what does that say about me?
It says you are behind the times. That procedure is one of the new features in "Denali".
And here I was thinking it was a new feature in "Denial"
I really considered rewriting that name of that proc to camelcase it - but wanted to let it roll and see who would say something about it. Looks like a bunch made a Ken Jennings type of "rake" mistake.
Ken Jennings? I was more thinking along the lines of expertsexchange.com.
- 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 17, 2011 at 11:52 am
GSquared (2/17/2011)
CirquedeSQLeil (2/17/2011)
Stefan Krzywicki (2/17/2011)
Jack Corbett (2/17/2011)
george sibbald (2/17/2011)
Koen Verbeeck (2/16/2011)
Jeff Moden (2/16/2011)
CirquedeSQLeil (2/16/2011)
For the execution of Wayne:
--get spid of code requestor
sp_whorequestedcodeIntheThread 'Wayne'
--use returned spids to verify the request
dbcc inputbuffer(61)
--output
'Wayne definitely requested code on the thread'
--yup that's the one
Kill 'Wayne'
just one bad underscore in the name of that sp could change its meaning entirely. 😛
Great, I'm glad I'm not the only one with a dirty mind 😀
when I saw it my FIRST thought was 'that should really be prefixed usp_' - what does that say about me?
It says you are behind the times. That procedure is one of the new features in "Denali".
And here I was thinking it was a new feature in "Denial"
I really considered rewriting that name of that proc to camelcase it - but wanted to let it roll and see who would say something about it. Looks like a bunch made a Ken Jennings type of "rake" mistake.
Ken Jennings? I was more thinking along the lines of expertsexchange.com.
Until you just mentioned it I don't think I ever quite caught that one... 😛
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
Viewing 15 posts - 24,061 through 24,075 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply