May 6, 2009 at 5:53 pm
john.arnott (5/6/2009)
Alvin Ramard (5/6/2009)
john.arnott (5/6/2009)
4KLynn, let me know if you understand the OP's last reply in the thread about the rolling 12 months. I don't think he knows what you meant about indexes.
Steve,
Is there something wrong with the "Quote" button?
I think there must be -- I've no idea what my playful claim on post 4096 has to do with a "rolling 12 months" thread. I've seen other such non-sequiturs and have had weird quote behavior myself.
I believe that was my fault. It think I clicked on Quote instead of Reply
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 6, 2009 at 8:21 pm
GilaMonster (5/6/2009)
Florian Reischl (5/6/2009)
:sick:
CREATE SCHEMA [%]GO
CREATE TABLE [%].[%] (Id INT IDENTITY PRIMARY KEY, i INT, [-] INT, [AND] INT, [*] INT, [%] VARCHAR(10))
CREATE INDEX [master.sys.objects] ON [%].[%] ([-]) INCLUDE ([*])
INSERT INTO [%].[%] SELECT 1, 2, 3, 4, 'blah'
SELECT i + [-] * [AND] % [*] [%]
FROM [%].[%]
WHERE [%].[%].[%] = 'blah'
Meh.
CREATE TABLE [['.[] ([,] int,
[[.] int,
[['.[.'] int,
[ FROM [['.[] varchar(4)
)
SELECT [.].[['.[.'], [.].[,],[.].[[.], [.].[['.[.']
, [.].[ FROM [['.[] [.], [.].[ FROM [['.[] FROM [['.[] [.],
[['.[] [ WHERE [['.[.[['.[.'=''] WHERE [ WHERE [['.[.[['.[.'=''].
[['.[.']=''
Edit: Looks like it confused the forum's syntax highlighting.
Heh. This reminds me of a SQL obfuscation technique that I came up with but never got to use. It goes like this:
1) Take an implemented DB design. Determine the object_id# and column_id# of every object and column. In binary.
2) Script all code-based objects, making sure to use quoted identifiers ("[schema].[name]")
3) Rename every object name and column name to be 32 characters long consisting a zero ("0") where a zero occurs in the binary bit pattern of the id and a capital "O" where a one would occur.
4) search and replace the script to make the same name changes, and then re-execute it.
This should result in stunning code like the following:
[font="Courier New"]
SELECT [0000000000000000000000000000000O]
, [000000000000000000000000000000O0]
, [000000000000000000000000000000OO]
From [00000000OOO0OOO000OOO000000OO00O]
Where [00000000000000000000000000000O0O] IS NOT NULL[/font]
Hackers should have fun reading a few thousand lines of that!
EDIT: (Hmm, the code font used here actually makes this much easier to read?)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 6, 2009 at 8:26 pm
Lynn Pettis (5/6/2009)
From the Merriam-Webster on-line dictionary:1 : of or relating to an uncle
2 : suggestive of an uncle especially in kindliness or geniality
Ah well, that's not too bad then. I mean he could have called me carbuncular, that's not too good. 😛
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 6, 2009 at 8:32 pm
[font="Verdana"]That reminds me of my FoxPlus days...
FoxPlus was an interpreted version of dBase, but ran somewhat faster. On an 8088 system, it still wasn't fast enough. So what I'd do is produce a "pseudo-compiled" version stripped that out all commends and replaced all variable and function names with one or two character names. That gave around (from memory) a 20% performance increase to the code.
So it was simple: there were two versions of the code. One was the commented, edit friendly version where all changes had to be made. The other was the run only version. You made your changes in the edit version and then ran it through the psuedo-compiler to produce the run version.
So imagine my surprise when I had a student come up to me next year telling me how utterly horrendous my code was to maintain! It turned out that after I left, they had given him the run only version of the code, despite my documentation that made it plain that there was an edit friendly version. He looked shocked when I mentioned there was a version of the code that had comments and meaningful names. Poor guy.
[/font]
May 6, 2009 at 10:51 pm
Indexing as in indexes on the database tables to make searches against the tables efficient so they don't cause massive locking and very slow queries. No app can provide that.
Obviously Gail hasn't talked (or, more properly, listened) to someone about his commercial-application-turned-public-domain-won't-anyone-please-love-me product, which shall not be named. It can do anything better because it's really-and-truly-more-relational-than-thou-stop-laughing-you-all-just-don't-understand.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 7, 2009 at 1:45 am
Alvin Ramard (5/6/2009)
Steve Jones - Editor (5/6/2009)
This thread feels like a Twitter stream.hmmmm.... Are you calling us Twits?
😀
Well I feel a twit for still reading all the posts... soooooo many .... :doze:
I must stop posting.............................
I must stop posting.............................
I must stop posting.............................
:ermm:
Far away is close at hand in the images of elsewhere.
Anon.
May 7, 2009 at 3:32 am
Bruce W Cassidy (5/6/2009)
[font="Verdana"]Algol 68 was a later revision to the language. However, it may have been the first version of PL/1. Been, er, 20 years since I looked at either, so memory is a bit rusty.[/font]
Algol 68 was the language which forced me to learn structured programming since I never managed to work out a legal place to put a label! 😀
Derek
May 7, 2009 at 4:38 am
Bob Hovious (5/6/2009)
Obviously Gail hasn't talked (or, more properly, listened) to someone about his commercial-application-turned-public-domain-won't-anyone-please-love-me product, which shall not be named. It can do anything better because it's really-and-truly-more-relational-than-thou-stop-laughing-you-all-just-don't-understand.
Nope. Don't have time or patience for listening to pointless rants.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 7, 2009 at 5:24 am
Google must be down again - http://www.sqlservercentral.com/Forums/Topic711884-146-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 7, 2009 at 6:11 am
Google is still down
http://www.sqlservercentral.com/Forums/Topic711917-145-1.aspx?Update=1
Edited: Typo
May 7, 2009 at 6:13 am
What about good?
What about evil?
What about right?
What about wrong?
Is there a Vorlon in the building?
"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
May 7, 2009 at 6:21 am
GilaMonster (5/7/2009)
Google must be down again - http://www.sqlservercentral.com/Forums/Topic711884-146-1.aspx
Which just gives credence to NOT use the number of posts as an indicator of skillset. Granted, 1200+ isn't huge compared to some of you here but it should indicate a bit of a non-newbie of sorts - until they open their mouths of course.
-- You can't be late until you show up.
May 7, 2009 at 6:24 am
Whoa! I didn't notice that guy had 1200 posts. What the heck is up with that? You take that much time and you still don't get silly fundamentals? And I'm called scary.
"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
May 7, 2009 at 6:28 am
... and then I really wanted to add "And I'm sure that during your undergraduate and graduate studies you had to know how to do independent research. This is especially true if you wish to persue a PhD."
No, I'm not posting a link to this thread either....
Edit: fix spelling error
Viewing 15 posts - 4,111 through 4,125 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply