- Feature Articles
- CodeSOD
- Error'd
-
Forums
-
Other Articles
- Random Article
- Alex's Soapbox
- Announcements
- Best of…
- Best of Email
- Best of the Sidebar
- Bring Your Own Code
- Coded Smorgasbord
- Mandatory Fun Day
- Off Topic
- Representative Line
- News Roundup
- Editor's Soapbox
- Software on the Rocks
- Souvenir Potpourri
- Sponsor Post
- Tales from the Interview
- The Daily WTF: Live
- Virtudyne
Admin
MSSQL added versioning (called snapshot isolation) in SQL Server 2005. It is an option that must be enabled on a database-by-database basis, because there is an overhead cost to copy every page to tempdb before updating.
Admin
No. It's a minimum requirement for posting here that you be able to click on the appropriate button. If you can't do so, please don't post. ;-)
Admin
No. The paracetamol of the software industry is "Java" or more specifically "Java frameworks" (which are just like "mushrooms") :)
Admin
Not a WTF. SQL Server is a Microsoft product name (and is trademarked). Using "SQL Server" to mean a different RDBMS is the WTF.
Admin
Correct me if I'm wrong, but I don't think that MySQL has a DUAL pseudo-table.
Admin
Ok. Finally the real WTF from you: Citing gnu as a definitive source about anything other than gnu related codebases.
Got it. Not only is gnu an authority on SQL Server's meaning, but so are the idiots who just decide to use the term incorrectly.
I guess that means that if I can find a couple of people to say that you're not an idiot too, you'll think that makes it so. Or if I can find a few people who think it's fine to drink a gallon of bourbon and then drive their cars on public streets, that makes it a good idea to drink and drive.
Just because you can find people doing something totally wrong doesn't magically make it right. It just proves they're morons if someone corrects them and they continue doing it.
So, Martin, SQL Server does not mean MySQL or PostgreSQL or SysDB or Oracle. Got it yet? Or are you one of those people who can't learn.
Admin
I think you're now spouting nonsense in a fruitless effort to prove your point, which is wrong.
The definition is quite easy:
If your software is used internally and isn't marketed for sale for others to use, your developers are overhead (they don't directly help generate revenue).
If your software is marketed for sales to someone other than your own company, your developers directly help generate revenue and therefore aren't overhead.
Is that simple enough for you?
Admin
Admin
Technically speaking, you're quite correct. From a practical standpoint, you're a dolt.
While it's true that the extremely small portion of the overall electric bill that powers the programmer's computers is not overhead, the remaining electricity is, and so is the salary of the person that you hire to keep track of what electricity is and isn't part of the overhead. You know, metering actual watts used by each computer on a constant basis so you can calculate the cost of those watts and deduct them from the overall electric bill so you can separate overhead and non-overhead costs.
Of course, for non-idiot business people, it's a no-brainer to just decide to count that small percentage of power against the overhead costs in order to avoid the much higher costs associated with the accounting and tracking of the comparatively small amount used by the PCs.
Of course, I can see you sitting at the side of a developer's desk, staring intently at the wall outlet. Dolt.
Admin
I had a marketing/sales guy at a company I worked for go at least a full year telling customers that we had a seperate backup "sequel" server. He had no Idea that our SQL Server was a database engine because he though "sequel" ment that it was a "second" server, and SQL was an abbreviation of the word "sequel"
His ignorance came to light one day duing a company meeting where we were trying to find ways to cut costs, and he suggested that shutdown our "sequel" server and force our customers to use their own backup tools. I promptly suggested that we do a company wide employee evaluation to weed out the incompetent.
Admin
I thought it meant Compact Disc Recordable
Admin
But it does give me warm fuzzies that you notice me. :)
Admin
When my company started to shere some data with XML, they put a non-technical person to be the first contact with our customers... I heard the say "And if you want to access our data, we have made something called XML"
Admin
You're right, I was wrong. I don't use the Express version, and I thought it lacked a usable user-interface management tool. A few people have corrected me on that.
The 2 GB file size limit on Express might be plenty for some small businesses, and if not, they can spend the $700 to buy the Standard version.
Admin
I do think so. In fact, I know so. It even has a user interface, as several people have pointed out. It can be used in a commercial environment for production use.
Admin
You're probably imagining wrong. SQL Server Express can be used in a production, corporate environment, for example. And it's not faceless.
Admin
Admin
Not to sound like a shill for MS, but.... writes don't block reads in MY installation of Microsoft SQL Server 2005. Tables don't get locked in their entirety; there are row-level and page-level locks. And when updates are fast, any blocking that might occur is very short-lived.
Admin
Admin
Your original argument was that a salaried employee was ipso facto "overhead." It's a bit much to shift gears down to the level where you're counting things in warm fuzzy fifteen-minute intervals.
Quoting from Wikipedia and the free online dictionary (again with an online dictionary? We've been here before) is not remotely definitive, either. Selective, most definitely. Indicative, possibly. Not definitive.
Outside the bounds of sophistry, most people would agree that "overhead" is an accountancy device and that we should therefore defer to the accountancy viewpoint on its meaning. That meaning may only be precise in terms of individual accounting practices, but it's a tight enough one for everyday use by the rest of us slobs.
If there's a statistical probability that what you do is contributing to a specific revenue earner, you are not "overhead." Anally retentive dingbats who count in fifteens because they have genetic defects like three feet, three hands, and only half a brain can safely be left out of the discussion.
Mind you, I once worked at a place where management insisted on such a system. They got the head of testing to write it for them. He was ex-Navy. He used VB4. I don't know what it is with these Navy types, but they sure like buttons -- big shiny buttons and little teeny drab buttons and everything in between; you couldn't even see an entry box without pressing several buttons. There were no drop-down lists or combo boxes; just buttons. The damn thing sprouted several more buttons every week. I swear it grew an extra button or two even while I was using it.
Of course, at the end of the month, management just threw away all the gibberish collected through this monstrosity and made up the figures to match targets required to meet their bonus schedule, just as they had done since time immemorial.
Perhaps we can agree on the concept of "button overhead?"
Admin
I really don't care how "overhead" is defined. I've always understood it to mean "operating costs", period. And as I mentioned before, I'm not an accountant, so if the accountants draw a finer line than that, I have no objection; I'm willing to accept it. Yawn.
I'm not sure why some of the respondents got all emotional about it, either. Strange behavior on here, sometimes.
By the way, the IT department (which consisted of the manager, four developers and one hardware guy) was the only one required to track time that way. Upper management liked to have observable results for their labor, and I guess it rankled that we would be sitting typing away for months and them not have evidence of anything getting done. A couple of us wrote (in VB6!) a win32 app that tracked our time. It even had a fancy-schmancy icon in the taskbar tray. Writing it was fun. Using it was not.
So in our case, I guess it was "tray icon overhead".
Admin
Admin
I ran into a similar situation some years ago, the customer had this nice shiny Oracle database and really, really wanted to use it for the project we were involved with. Only problem was there wasn't anything that could be (sensibly) stored in a database. However, they were quite insistent that the project use their Oracle database.
In the end we shipped them a database containing a single table, and that table contained a single entry, which was a blob that stored the config file for the project. They were happy because they were using an Oracle Database(tm) to run things, and that had to be a good thing.
Admin
Admin
Admin
Speaking as a Marketing guy who works with engineers on a regular basis. When it comes to buzz words like your Oracle brand, customers don't necessarily know its functionality. All they know is what people tell them. They assume the best option for the job is the bigger brand name. Like Sony is the best in everything they make right!lol needtoknowbasisforbusiness.blogspot.com
Admin
Just like PostgreSQL in fact. (At a fraction of the price).
Who said anything about a pseudo table?
The original comment was that only Oracle can do 'SELECT X FROM DUAL'.
In fact, any SQL server (generic term) can do that:
CREATE TABLE DUAL (X INTEGER); SELECT X FROM DUAL;
There, done.
Admin
OK, got it. I completely misread the second and third paragraphs.
Admin
No, Oracle can't do that. But then Oracle is a database, not an SQL server, so your statement stands I suppose.
Admin
I worked in a garage for two years in high school - green, orange, yellow, and red coolants are in fact incompatible chemically. Green is standard cheapo, as I recall red is toyota's long-life coolant, yellow is ford's long-life, and orange is some other company's long-life. Do not mix them, but if you drain all your coolant out, say, while replacing the radiator or just as part of a system flush, you can put whichever one you want in afterwards. Just don't ever mix them.
Admin
In summary; the sociopaths that constitute upper management don't have the time or inclination to understand anything in detail; they only want a 5-minute presentation if it comes with pictures. But they have to approve all the spends. So to sell a solution you have to cram all the good bits into tiny soundbites and fit them all into 5 minutes. Look at low-end advertising; it's all about branding ("Oracle"), vague assertions ("reliable"), and buzzwords ("enterprise"). And if it doesn't cost a lot, it can't be worth buying.
Admin
i have install my pc win detective so my pc is slow working pls tell how to uninstall windetective