Slashdot Mirror


User: SQLGuru

SQLGuru's activity in the archive.

Stories
0
Comments
2,026
First seen
Last seen
Profile
(view on slashdot.org)

Comments · 2,026

  1. How to build something cool.... on What's the Coolest Thing You've Ever Built? · · Score: 1

    Instructions:

    1. Get some PVC pipe
    2. Locate a 50% solution of H2O2
    3. ????
    4. And there it is.

    Layne

  2. Re:Well.. on Google Answers Closing Up Shop · · Score: 1

    As an FYI, EXISTS performs slightly better than an IN for most queries with no major change in the code. EXISTS gets to benefit from stopping once a match is found as opposed to running the entire sub-query before searching the results. The only time they are close in performance is when what you are matching is at the end of the list. And then, they are more or less equal.

    Of course, I normally change my code to read:

    select from Table where exists( select 'TRUE' from Sub-Table where )

    Instead of

    select from Table where in ( select from Sub-Table where )

    But that isn't required to get the benefit of an EXIST clause.

    Layne

  3. Re:Well.. on Google Answers Closing Up Shop · · Score: 2, Interesting

    I do admit it is funny and somewhat ironic, but I chalk it up to my SQL background as to why I DON'T use the operators when searching. I tend to use multiple windows/tabs to search, so if I'm going to do an OR, I'll just run the query in two windows. When you throw an OR into a SQL query, you can kill performance of that query. A lot fo the time a UNION of two result sets is faster than the same query with an OR (sometimes not, Query tuning is a form of technical voodoo). Of the operators, the one I use most frequently is -, but again, only when normal methods fail. A NOT operator doesn't use an index well.

    As a side note, I prefer multiple windows vs multiple tabs. With tabbed browsing, all pages are running in the same memory space. If one result has a bad page (by bad, I mean slow / resource intensive), it bogs them all down. I have my browser set to run each different instance in a different memory space. New window means that the others still perform ok. And if I need to kill the offender, it doesn't take all of my windows with it.

    Layne

  4. Re:Well.. on Google Answers Closing Up Shop · · Score: 5, Informative

    Yeah, I second the "good searching skills" vote. My rule of thumb is that if I'm trying to find something and it takes longer than 2 hours, it isn't really available on the Internet. Most things take less than 15 minutes, obscure things less than 45.

    For those who aren't good at finding things the following are some good tips:
    1. A good vocabulary / thesarus is very handy (which rules out half of /. already).
    2. Good and bad spelling is important. Just because you can / can't spell a word, doesn't mean that everyone else can / can't.
    3. Word order can be important, too (even on engines that say it isn't).
    4. While I rarely use operators (AND, OR, -, etc.), knowing them is good for that hard to find query.
    5. Quotes around multiple words are more important that the operators. It means that the words have to appear together and in that order.
    6. My engine of choice is Google, but targeted engines might get you better results.

    Other links to useful tips:
    http://www.internettutorials.net/search.html
    http://www.monash.com/spidap.html
    http://www.extremesearcher.com/handbooklinks.html

    Layne

  5. Re:So the obvious security hole wasn't mentioned? on First-Person Account of a Social Engineering Attack · · Score: 1

    A quick and easy way to spoof a MAC address (no hacking knowledge required).

    Get a Netgear wireless router (I'm sure other brands work, too, but the one I have is a Netgear). In the set-up, it asks if you want to use the MAC of the router or another MAC that you specify. Plug in whatever value you want. Instant MAC spoofing. And it's all configurable by a Web page, so even a no0b can do it.

    Layne

  6. Re:negative vs positive on First-Person Account of a Social Engineering Attack · · Score: 1

    You pay to figure out if you are the 1 or in the group of 9. If you are in the group of 9, you need to spend more on security training / awareness. Training the whole branch office is likely to cost a whole lot more than the cost of the assessment. If you are in the 1, then you've avoided the full cost. If you are in the 9, then the cost of the assessment is easily absorbed into the total cost of securing the branch.

    Layne

  7. Re:Straight from the horse's mouth on MPAA Goes After Home Entertainment Systems · · Score: 1

    Wow, I thought that certain institutions were exempt (well, subject to modified rules) like a lot of other things. So, every time my kids schools have movie day they are violating copyright law. Same for day cares that use movies to entertain the kids.

    And what about when I'm driving down the highway and my kids are watching something in the mini-van? If you can see the movie from your car (and can hear it from the FM transmitter), does that mean that I'm violating copyright law because it becomes a public performance?

    Layne

  8. Re:Probability theory on Milky Way Star Births May Have Influenced Life · · Score: 1

    And just because the probability is 1 in X, doesn't mean that an event can't occur more than 1 times.

    Proof:
    The chance of a die landing on 3 for a given roll is 1 in 6. If I roll a die six times, how many times will it land on 3? On AVERAGE, 1, but for a specific set of 6 rolls, it could be as high as 6.

    So, if the odds that life would develop around a star (not counting bodies orbiting that star -- I am reluctant to use the term planet because Pluto could house life and is not longer considered [by others] to be a planet); so if the odds are 1 in Q where Q is the number of stars in the universe, there is still the chance that more than 1 stars rolled a natural 20 on their Chance for Life roll.

    Layne

  9. Re:VERY IMPORTANT on Why the Word 'Planet' Will Never Be Defined · · Score: 3, Informative

    The parent post is spam. Please do not click it. It redirects to http://31337.pl/

    Layne

  10. Vista? on Flexible Photo Organization Software? · · Score: 1
  11. INTERNET Explorer on How Would You Usurp the Web Browser? · · Score: 1

    The browser will not go away. It may expand to include more functionality, but it won't go away. People like "one stop shopping". It's called INTERNET Explorer for a reason.

    Hyper Text - http://slashdot.org/
    Gopher - gopher://seanm.ca/
    WAIS - wais://stardust.jpl.nasa.gov:210//home/wais/wais-s ources/dpw?
    File transfer - ftp://ftp.wustl.edu/
    Telnet - telnet://locis.loc.gov/
    Multimedia Streams - mms:media1csuseduusrvideodemosamplewmv

    etc.

    The browser handles all of these activities in a single platform (either natively or through "handlers" - plug-ins if you will). Make a new protocol for applications if you want, the browser will likely be expanded to support the protocol (first via plug-ins, later natively). As a Web surfer, I don't want to have to know which program to run in order to accomplish my task (read docs, play games, use apps, etc.). I want to run one program (my browser) and have all of that "MAGIC" take place behind the scenes.

    Layne

    (P.S. Sorry if some of the links don't work, I'm at work and some of them are blocked. They were all copied from pages that purported them to be working example links.)

  12. Re:So what? on Peter Jackson Will Not Be Making The Hobbit · · Score: 1

    Was that possibly his point?

    Layne

  13. Re:Peter Jackson on Peter Jackson Will Not Be Making The Hobbit · · Score: 1

    Given the choice, I'll take Jackson's "butchering" over that animated crap we had before. I agree with the guy that talked about "Which Lie Did I Tell?" (several posts ^^^ by now). Jackson's movies are visually appealing, entertaining, and true enough to the story that I didn't take a lot of issue with them. The main fault in my mind was the Arwen love story part. The rest of it was acceptable/tolerable deviations.

    Layne

  14. Re:Someone please explain on Second Life Hit By Massive In-Game Worm · · Score: 2, Funny

    But the graphics made the web better than Gopher (or WAIS). The graphics led to pr0n.

    Layne

  15. Re:I agree on A Master's In CS or a Master's In Game Programming? · · Score: 1

    I've got a BS-CS degree, but I'm taking this program (http://www.austincc.edu/techcert/Video_Games.html ) which, one of the things that drew me to it was that the instructors and directors of the program are all in the industry and employed full time or run their own companies. While it isn't an accredited degree program, I think a program similar to this combined with a "real" degree (MS-CS if you want the massters level) would be the most beneficial way to go. Many in the games industry in town (Austin, TX) do recognize the program as having some merit.

    Layne

  16. Re:CompSci maths... on What Math Courses Should We Teach CS Students? · · Score: 1

    Once SlashDot enables the F7 key when I post my P.O.T. comments, my spelling will "improve".

    (For those not keyboard friendly, that would be Tools / Spelling and Grammer in your MS Word application.)

    Layne

  17. Re:ballpark on What Math Courses Should We Teach CS Students? · · Score: 1

    Two, but one is an Apple IIGS and pretty much worthless.

    Layne

  18. Re:Some Math greater than Other Math on What Math Courses Should We Teach CS Students? · · Score: 4, Informative

    I would say that it depends on the focus of the student.

    Graphics programming - Linear Algebra (matrix math) would be invaluable
    Business application programming - plain old Algebra and maybe some statistics
    Engineering apps - physics / calculus, stats
    Compression programming - linear algebra, "new math"
    etc.

    When I was in college (90 to 94) at an engineering school, my CS degree required Calculus through the third one (because it was in the Engineering department) and statistics (because otherwise, noone in their right mind would ever take statistics) and an elective "math" the your advisor would point you towards based on what type of work you were interested in doing. I think this approach has worked out well for me.

    Layne

  19. My walls! on Physicists Promise Wireless Power · · Score: 1

    I would love to see this come to market. Instead of plugs, my house would have resonant antennas embedded in all of the walls. Then, I can just put things whereever I want them. They'll get the power they need (~15ft gives 30ft coverage, no room in my house is that big). The only concern would be with reception (such as cell phone or FM) with that copper Faraday cage in all of the walls. TV wouldn't be much of a problem because my TV antenna is this DirecTV dish sitting on my roof and my internet comes from my cable company through this black "tube".

    Layne

  20. Re:With open source the same problem exists on The Importance of OS Backwards Compatibility · · Score: 1
    Not possible - no one supports that old version.


    1. Hire all of the laid off customer service reps that lost their jobs to India
    2. Contiue to support all of the old versions
    3. Profit!!!

    Notice there isn't a line about ???? in there.

    Layne
  21. Re:well on The Importance of OS Backwards Compatibility · · Score: 1

    Who needs backwards compatibility. My Commodore 64 still runs all of my Commodore 64 programs. My XBox still plays all of my XBox games. My DOS games still run great under DOS 5.0 (6.2 and 6.22 were where MS started pushing bloatware over beneficial functionality).

    I'm in favor of trimming some of the fat. If MS has a 3 version back support policy for the OS itself, why not have a 3 version back support policy for any features. After 3 versions, you may or may not get to keep your API. They do it with other areas (for example, SQL Server has not guarantee that certain features will be supported in the next release and MS recommends that you update your code).

    Layne

  22. Re:Major Vs Minor on Scientists Create Air Guitar T-shirt · · Score: 1

    This technology has existed for quite a while. My step-daughter had one of these (http://www.trademe.co.nz/Toys-models/Battery-wind up/photos/a-76582917/p-29182841.htm) when she was 3. I could jam out to a rockin' version of the Sesame Street theme song just by moving my hands......and I don't know diddly about music.

    Layne

  23. It ain't racism, it's humor on Robot Identifies Human Flesh As Bacon · · Score: 1

    Human, the other, other white meat....

    Layne

  24. Re:If stuck... on 2006 NetHack Tournament · · Score: 1

    I'd recommend one pass through the game in Wizard mode (see documentation on how to enable it). You get to see everything and it doesn't resort to save scumming (since you can prevent death). Plus, you don't pollute the high score table. Then, try to repeat in normal mode. Repeat until successful.

    Layne

  25. Re:Heatsink is supposed to be that hot... on Cooking With the XBox 360 · · Score: 1
    Taking this even FURTHER off topic:

    "$30 for the One True Ring. $10 each additional ring!" -- JRR "Bob" Tolkien


    Actually, if you check here http://www.badalijewelry.com/tolkien.htm (and you can read about the licensing of them here: http://www.badalijewelry.com/forging.htm, which may or may not be valid still). But the rings cost differently depending on what metal you order them in ($480 for the One True Ring in 10k gold up to $896 in 22k yellow gold). You can read the rest of the site to see how much it would cost to have the entire collection.

    Layne