February 25, 2011 at 4:49 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 got part way through the test setup and had to put it aside. Real work caught up with me. 😛
uf curs ah gots ta haz abito funz hurinder too! 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2011 at 5:43 pm
Took the MCM test today. It was....interesting. I'll write more about it once I know what I can and can't say.
February 25, 2011 at 6:13 pm
Steve Jones - SSC Editor (2/25/2011)
Took the MCM test today. It was....interesting. I'll write more about it once I know what I can and can't say.
How did it go? Feel like your brain is mush now?
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 6:36 pm
Not sure what I can say about the exam, so I'll hold off. Look for a blog next week once I clear a few things up with NDA
February 25, 2011 at 6:41 pm
Jeff Moden (2/25/2011)
uf curs ah gots ta haz abito funz hurinder too! 😛
I don't get this 'hurinder" part...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
February 25, 2011 at 8:01 pm
WayneS (2/25/2011)
Jeff Moden (2/25/2011)
uf curs ah gots ta haz abito funz hurinder too! 😛I don't get this 'hurinder" part...
"Here'n'There". 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
February 26, 2011 at 1:03 pm
WayneS (2/25/2011)
Jeff Moden (2/25/2011)
uf curs ah gots ta haz abito funz hurinder too! 😛I don't get this 'hurinder" part...
here and there
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 26, 2011 at 1:04 pm
Jeff Moden (2/25/2011)
WayneS (2/25/2011)
Jeff Moden (2/25/2011)
uf curs ah gots ta haz abito funz hurinder too! 😛I don't get this 'hurinder" part...
"Here'n'There". 😛
d'oh - responded before flipping the page.
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 26, 2011 at 2:32 pm
Jeff Moden (2/25/2011)
I got part way through the test setup and had to put it aside. Real work caught up with me. 😛uf curs ah gots ta haz abito funz hurinder too! 😛
Ho pew duza tlakk wik and rights it lakdis 2. :hehe:
Tom
February 28, 2011 at 6:39 am
Jeff Moden (2/25/2011)
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. 🙂
Yes. With Encryption is junk. A batch trace defeats it, if I remember correctly.
- 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 28, 2011 at 7:01 am
GSquared (2/28/2011)
Jeff Moden (2/25/2011)
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. 🙂
Yes. With Encryption is junk. A batch trace defeats it, if I remember correctly.
Unless written by Tom or Jeff.
Tom.Thomson (2/26/2011)
Jeff Moden (2/25/2011)
I got part way through the test setup and had to put it aside. Real work caught up with me. 😛uf curs ah gots ta haz abito funz hurinder too! 😛
Ho pew duza tlakk wik and rights it lakdis 2. :hehe:
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
February 28, 2011 at 7:09 am
GSquared (2/28/2011)
Yes. With Encryption is junk. A batch trace defeats it, if I remember correctly.
And it uses a very easily reversible algorithm - I think Red Gate SQL Compare even has an option to automatically decrypt them so you can still script them.
February 28, 2011 at 8:19 am
Jeff Moden (2/25/2011)
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. 😀
ROTFLOL.
February 28, 2011 at 8:20 am
HowardW (2/28/2011)
GSquared (2/28/2011)
Yes. With Encryption is junk. A batch trace defeats it, if I remember correctly.And it uses a very easily reversible algorithm - I think Red Gate SQL Compare even has an option to automatically decrypt them so you can still script them.
Doesn't matter. They could improve the encryption till it's unbreakable, and it still needs to be run in the engine the same way as any other DML/DDL command, which means a trace can show it. If a trace can't, then C2 auditing can't, and that breaks all kinds of legal and security issues.
That's why, when Steve asked the original question, I asked whether he meant, "are people trying to protect their IP?", or "are people doing completely ineffective things in vain attempts to protect IP?".
You have to assume, if it can be installed on a machine that's not under your control, that the code will be known sooner or later. I think that's one of the reasons some companies are interested in "cloud computing", because then their code is on their server, and you can't reverse-compile it on your local machine.
- 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 28, 2011 at 8:24 am
GSquared (2/28/2011)
I think that's one of the reasons some companies are interested in "cloud computing", because then their code is on their server, and you can't reverse-compile it on your local machine.
I always understood cloud computing to be your code on someone else's server across the internet. Granted, I can see it being set up in a WAN, but we've already got server based code in WAN / LAN environments, which doesn't strike me as the being the same thing as cloud.
Viewing 15 posts - 24,346 through 24,360 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply