Forgot your password?
typodupeerror

+ - Result of a Simple SQL Indexing Quiz: 60% Fail->

Submitted by Anonymous Coward
An anonymous reader writes "The analysis of 28.000 results suggests that hardly anybody knows how to get indexes right. In the simple multiple-choice test, merely 38% passed — guessing alone would result in 12.5%. Just 10% managed to answer all five questions correctly. When the story broke on Reddit, doubts about the validity of the results were raised. On the one hand, people bring up examples to show that the quiz is actually wrong so the conclusion is wrong too. In the top voted comment, however, a Redditor admits “It's even worse, IMO. I, for instance, got 3 out 5. But I got 2 of them for the wrong reasons. So, in fact, I only knew the answer for 1 out of 5.” Could it really be that bad?"
Link to Original Source

Comment: A few free resources (Score 2) 106

by mws (#44270363) Attached to: Ask Slashdot: Learning DB the Right Way; Books, Tutorials, or What?
Practical PostgreSQL: http://www.commandprompt.com/ppbook/
Learn SQL The Hard Way: http://sql.learncodethehardway.org/
Use The Index, Luke!: A Guide To SQL Database Performance: http://use-the-index-luke.com/ (my own site)
Source: http://stackoverflow.com/questions/194812/list-of-freely-available-programming-books

+ - Making SQL Fast: Use The Index, Luke!->

Submitted by mws
mws (170981) writes "SQL performance has been an issue ever since. Developers all over the world spend hours staring at SQL statements every day—just to figure out why some are running fast, but others are not. Use The Index, Luke! explains just that. It's a guide to SQL performance that puts all parts of SQL in context of the database performance workhorse: the index."
Link to Original Source
Science

+ - Video Showing Half A Million Asteroid Discoveries->

Submitted by Anonymous Coward
An anonymous reader writes "Since 1980 over a half million asteroids have been discovered, mostly between the orbits of Mars and Jupiter, now thanks to this video you can see this activity condensed into a few minutes. At full resolution it's a mesmerizing experience as new discoveries are added and the video makes it possible to see patterns in the discovery positions, for example a large number appear in line between Earth and Jupiter as astronomers started looking for smaller jovian moons after Voyagers visit to the system."
Link to Original Source

+ - SPAM: Tata regrets the fall-out of Nano project

Submitted by Anonymous Coward
An anonymous reader writes "Tata group, one of the oldest industrial group, seems to be regretting the political agitation faced in the year 2008 at Singur due to which the company had to shift its Nano project to Sanand in Gujarat. The group's Chairman, Mr Ratan Tata said on Monday that he regrets that Tata Motors could not do the Nano car project which was scheduled for West Bengal."
Link to Original Source

Comment: Re:Say goodbye for XML (Score 1) 272

by Insanity Defense (#30533666) Attached to: Microsoft Ordered To Pay $290M, Stop Selling Word

Are you serious? What kind of small company actually designs "...software...which they showed to Microsoft..." and doesn't expect

a) the ideas to be stolen by Microsoft.

b) be bought out by Microsoft.

c) be "corporate cannibalized" by Microsoft.

d) ALL OF THE ABOVE!

This was around the time that Microsoft was being tried and convicted on anti trust grounds in the U.S. and supposedly was reforming into a "kinder gentler" Microsoft that didn't resemble the black widow spider any more.

Comment: Re:Why? (Score 2, Insightful) 283

by Stan Vassilev (#30533402) Attached to: Windows 7 May Finally Get IPv6 Deployed

In most of our lifetimes? Per Wikipedia:

The very large IPv6 address space supports a total of 2^128 (about 3.4×10^38) addresses--or approximately 5×10^28 (roughly 2^95) addresses for each of the roughly 6.5 billion (6.5×10^9) people alive in 2006. In a different perspective, this is 2^52 (about 4.5×10^15) addresses for every observable star in the known universe.

It will take way more than poor management to use up all those numbers in any timescale with meaning to a human life.

That quote from Wikipedia you pulled, is immediately followed by this:

"While these numbers are impressive, it was not the intent of the designers of the IPv6 address space to assure geographical saturation with usable addresses. Rather, the longer addresses allow a better, systematic, hierarchical allocation of addresses and efficient route aggregation."

If we could arbitrarily ignore the network structure and special ranges assigned in IPv4, we have 4.2 billion possible IP numbers (2^32). Do we have 4 billion computers on the Internet? No. Do we have IPv4 shortage? Yes. In fact we had IPv4 shortage even back in the early 90-s when Internet was far from being mainstream yet (which prompted the jump from classful network to CIDR).

There are three kinds of people: men, women, and unix.

Working...