buckbova

57 ms·

601.
by buckbova 13y ago
I don't understand what you mean "trick". SELECT date_column, count(*) FROM tbl WHERE a = @a AND b = @b GROUP BY date_column; The "AND b = @b" causes the sql engine to access data in the table inst
602.
by buckbova 13y ago
It's much simpler than that. The first query only has to reference the index because the data is IN the index. The second query has to access the table. That's it. It's called a covering index.
603.
by buckbova 13y ago
A useless word I see used often is "just" as in "you just do" or "i just need". For me, it implies triviality or adds nothing.
604.
by buckbova 13y ago
No, because being a cop is a shit job and it wears on those who take it on. So, the nice guy eventually becomes a prick.
605.
by buckbova 13y ago
I've started off in worse situations than the OP. Apologize but not profusely. Then, shut up. Acknowledge the officer's authority, show some respect, and do as your told. Do it whether they deserve it or not. It's about makin
606.
by buckbova 13y ago
> I begged them to watch out for my recently broken right elbow. They don't give a shit about your elbow nor should they. Everyone who gets put in cuffs complains about some current or former injury. I'm not sure I buy every s
607.
by buckbova 13y ago
No, I wouldn't say ashamed. When I first started out, I would not let there be something I didn't have some knowledge about. So, after work I'd go home and study or work until I understood everything I could about my positio
608.
by buckbova 13y ago
Is this accurate to elastic search since it is build on Lucene? https://lucene.apache.org/core/ "index size roughly 20-30% the size of text indexed" That seems excessive for an index.
609.
by buckbova 13y ago
I didn't know what this was and looking at this link it was tough to tell. The github lays it out well. https://github.com/elasticsearch/elasticsearch
610.
by buckbova 13y ago
I never studied up to my second year of college. I took geometry in my first year of high school and struck a deal with the teacher that if I got an A on every test I wouldn't need to turn in any homework. I never took notes. I entere
611.
by buckbova 13y ago
Most difficult part for me is letting go. I am compelled to febreeze every bit of code smell I come across. I often rewrite large sections of working code into better structures, more readable/concise syntax, better naming of variables
612.
by buckbova 13y ago
You should have kept reading: > When I’d finished this article, I wanted to spell check the content. At this particular time emacs-ispell mode decided to that it could not find aspell, the program that I use for spelling checking. Does e
613.
by buckbova 13y ago
As a database architect I disapprove of this message. Nearly everything is revisited and changed at some point over the life of the product. If the initial design is a hack or not well thought out, the change will likewise be uglier than th
614.
by buckbova 13y ago
Classic bait and switch. Get multitudes to sign up for Prime over the holidays and then bump the cost.
615.
by buckbova 13y ago
Message to Mexico. Tend to your own backyard and stop dumping sewage in our ocean. http://www.sandiego6.com/story/county-issues-contamination-w...
616.
by buckbova 13y ago
"Stack Overflow runs off a single server" that is a cluster of how many physical servers with how many processors and how much ram? Three Dell R720xd database servers (two in New York City, one in Oregon, using SQL AlwaysOn Cl
617.
by buckbova 13y ago
Yes, hot-air balloons. Sign me up.
618.
by buckbova 13y ago
How many of those are incarcerated for "digital" crimes?
619.
by buckbova 13y ago
"In Windows Phone and Windows 8+ I can pin People to the Start Screen. It's a killer feature that no one talks about." This isn't new, my android gingerbread (2.3) phone does this. FWIW I'm going to upgrade this yea
620.
by buckbova 13y ago
I think there's value, but very little. A list of 50 items uncategorized with minimal descriptions and a screenshot is not enough to grasp what each tool is, what it does, and why I should use it. Basically, why is it awesome? If the
621.
by buckbova 13y ago
What takes up the majority of the time in your day? Try these: * Sleep one hour less a night. * Don't drink alcohol. * Prepare all food for the week in advance. * Cut down your time from awake to shaved, showered, dressed to 15 minutes
622.
by buckbova 13y ago
One thing I can suggest. Don't commute to work and if you do make it as short as possible. This time is wasted.
623.
by buckbova 13y ago
It wasn't the twentieth anniversary mac, originally priced over seven thousand dollars. http://www.mac512.com/Twentieth_Anniversary_Macintosh.html
624.
by buckbova 13y ago
And then there are table statistics or fragmented indexes that cause the optimizer to choose a different path. Even when you've done everything and you think the optimizer should choose a particular index it will surprise you.
625.
by buckbova 13y ago
I think it's dead man walking, especially with an unsustainable revenue base.
626.
by buckbova 13y ago
There's no better deterrent than racking a shell into your shot gun.
627.
by buckbova 13y ago
I will not click.
628.
by buckbova 13y ago
I love shiny new things and will keep on collecting them. Thanks to this article, I may have found some more. It pointed to the 2007 article, well here's the latest Scott Hanselmans Ultimate Dev Tools: http://www.hanselman.c
629.
by buckbova 13y ago
It goes the other way too, see rhino: https://developer.mozilla.org/en-US/docs/Rhino/Overview
630.
by buckbova 13y ago
Switched to DuckDuckGo for searches from the desktop a year ago. Just to give someone else a chance.

More ›