February 25, 2011 at 8:53 am
Jeff Moden (2/17/2011)
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 - have you made any progress with this yet?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
February 25, 2011 at 8:55 am
Steve Jones - SSC Editor (2/25/2011)
Stefan Krzywicki (2/25/2011)
But with TV and print media, we're so accustomed to ignore that advertising that we automatically divert our attention during commercials and readily ignore print ads. I honestly tend to notice web ads at least as much as tv and print ads, frequently more as they have a better chance of being something I'm interested in.
That might be true for you, but overall, web ads have been shown to be less effective than print and TV, still today. Most people think they ignore them, but they really don't. They are more engaged in the medium because it's just more focused.
I'll have to look for recent studies that show that. The ones I remember are around 10 years old by now and were seriously flawed.
--------------------------------------
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 25, 2011 at 3:26 pm
SQLkiwi (2/24/2011)
David Benoit (2/24/2011)
I remember when I took my first programming class, Pascal (Turbo actually)...I did a term using Turbo Pascal at University too.
Hmm - high school for me
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 25, 2011 at 3:27 pm
SQLkiwi (2/24/2011)
Ian Scarlett (2/24/2011)
SQLkiwi (2/24/2011)
David Benoit (2/24/2011)
I remember when I took my first programming class, Pascal (Turbo actually)...I did a term using Turbo Pascal at University too.
OMG, that makes me feel REALLY old. Turbo Pascal hadn't even been invented when I wrote my first commercial program (COBOL) :blink:
I hadn't realized until just now that 'Ten Centuries' was your age, not points rank :w00t:
Ouch 😀
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 25, 2011 at 3:31 pm
CirquedeSQLeil (2/25/2011)
SQLkiwi (2/24/2011)
David Benoit (2/24/2011)
I remember when I took my first programming class, Pascal (Turbo actually)...I did a term using Turbo Pascal at University too.
Hmm - high school for me
Not far off for me. It was first year of college in 87. Small town though so that might have been behind the times a bit.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 25, 2011 at 3:31 pm
Roy Ernest (2/25/2011)
I was sick for the past week, today I check the THREAD, I have no clue where it is heading. I do not think I will be able to catch up with the THREAD.
Feeling the same way about it. The thread moves at the speed of ... well something.
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 25, 2011 at 3:32 pm
WayneS (2/25/2011)
Jeff Moden (2/17/2011)
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 - have you made any progress with this yet?
I really want to take a gander at it too
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 25, 2011 at 3:59 pm
LutzM (2/22/2011)
Jeff Moden (2/21/2011)
...I dun no... DE-troit boy goin ta ohia mur dan wonce in da sames yer mite git da kin folk resluss en tha lak.
Here's my ESL approach:
Detroit boy going to Ohio more than once in the same year might get the kind folk restless on the lake.
As a side note: I didn't have to slow dow even a tiny bit to read it - since I have to look up each and every written word anyway 😀
"and the like". 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2011 at 4:03 pm
Tom.Thomson (2/22/2011)
GilaMonster (2/21/2011)
GSquared (2/21/2011)
jcrawf02 (2/21/2011)
Jeff Moden (2/21/2011)
jcrawf02 (2/21/2011)
Jeff Moden (2/21/2011)
WayneS (2/20/2011)
For those going to SQL Saturday #69 in Philly, I'll be presenting @ 2:15. I'm getting pretty excited about this!@Grant, Steve, Jeff - any chance of meeting up with you there?
No chance for me. I just started a new job and used up some serious brownie points on getting to SQLSaturday #60.
Are you going to make it to 70-whatever in Columbus? I totally flaked on you guys for the Cleveland one, wasn't a good time for me personally, much as I would have loved to meet you all.
I dun no... DE-troit boy goin ta ohia mur dan wonce in da sames yer mite git da kin folk resluss en tha lak.
Bummer. I should be worried that I didn't even have to read that twice... :hehe:
I had to slow down while I read it. Good thing Jeff types slowly...
I read it 4 times and still can't figure it out
Please speak proper English 😉
But that was proper English (just as one would expect from Geoff there's nothing at all improper about it).
:hehe:
Huh... kuret! mr werdz. cm letters? 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2011 at 4:10 pm
SQLkiwi (2/22/2011)
Steve Jones - SSC Editor (2/22/2011)
On a similar debating note, does anyone know of code in SQL Server that's worth protecting with CLR, obfuscation, or any hassles of encrypting? Not data, but code?In my limited experience, the only time I have seen attempts at obfuscation have been to hide the poor quality of the code. Seriously.
I don't know if that's why some of the folks I've seen using simple WITH ENCRYPTION are using it but, I agree, that it sure does seem that way. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2011 at 4:13 pm
Jack Corbett (2/22/2011)
Steve Jones - SSC Editor (2/22/2011)
On a similar debating note, does anyone know of code in SQL Server that's worth protecting with CLR, obfuscation, or any hassles of encrypting? Not data, but code?I have not. My opinion is that if you need to protect the code, and if it is really proprietary, it belongs in the business layer, not the database.
I agree... but only because it's so bloody difficult to hide code in the database.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2011 at 4:23 pm
jcrawf02 (2/23/2011)
Brandie Tarvin (2/23/2011)
LutzM (2/22/2011)
Jeff Moden (2/21/2011)
...I dun no... DE-troit boy goin ta ohia mur dan wonce in da sames yer mite git da kin folk resluss en tha lak.
Here's my ESL approach:
Detroit boy going to Ohio more than once in the same year might get the kind folk restless on the lake.
Wow. What does it say about me that I understood this.
FYI: The last few words are "restless and the like," (meaning, "restless, uncomfortable, worried, etc.") not "restless on the lake."
*banjo music echoing from the hills*
mr nat banjos u hea. mr inurds ona brum handdal 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2011 at 4:27 pm
HowardW (2/24/2011)
What are people's thoughts on whether an update operation on a 10 million row table (a selective update, but probably around 1-2 million rows affected) holding 400,000+ Page locks? Shouldn't it just escalate to a table lock?Having some weird behaviour migrating a data warehouse ETL to a 2008 server, it's thowing up some "cannot obtain a lock resource" message every now and again...
Seems to have very different behaviour in 2005.
Will try to set up repeatable sample code and make a new thread, just wanted to check it's not a common issue/perfectly normal before doing so... Trying to avoid having to plaster the code with TABLOCK hints...
cm loks? nat gud! fawcet toob ah tablock. :hehe:
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2011 at 4:33 pm
Brandie Tarvin (2/24/2011)
Tom.Thomson (2/23/2011)
I don't see much point in attempting obfuscation if the enemy can see inside the database.That's a good point, Tom. But is "enemy" a good word choice here? Do businesses really see this as a war?
Just my humble opinion but, yes... it's war! Especially when it comes to high performance getting to the data in a database.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2011 at 4:46 pm
Stefan Krzywicki (2/24/2011)
Yeah, most beer ads annoy the hell out of me, not only are they primarily selling sex, everyone in them is stupid and an alcoholic.
ah kin pruv ah aint no alchy... ah dun goes ta da meetuns. 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 15 posts - 24,331 through 24,345 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply