News for hackers. Stuff that matters.
Re:PostgreSQL vs SQL Server installation Faceoff by rbanffy on Monday May 31, 2010 @10:27AM (#1392564)
With two digits, it could never be milliseconds. Milliseconds would require three digits and would be ludicrous to render them as the last digit would be just a blur.

Actually, it's frames. At 30 frames per second, frame number goes up to 29. On occasion, you may skip one, as 30 fps is actually 29.97 fps when you are talking about NTSC video timings.

And you seriously claim SQL Server is designed to run for years without restarting? A Windows box running for months without a restart (and without significant performance degradation) is already a technical accomplishment. For years? I never heard of such thing.

SQL Server is Microsoft's greatest software accomplishment and is a quite impressive body of work, but I see no reason to go with it unless your problem falls into the very narrow (and increasingly narrow) space between what SQL Server can do and what PostgreSQL (and MySQL) can do.

And in most cases, I would pick Oracle over MS SQL Server anyway.

Re:PostgreSQL vs SQL Server installation Faceoff by ams6110 on Monday May 31, 2010 @11:05AM (#1392636)
SQL Server is Microsoft's greatest software accomplishment and is a quite impressive body of work

SQL Server is (was) Sybase, Microsoft bought the rights to fork it and sell it as SQL Server somewhere back in the late 1990s. So the accomplishment is not entirely theirs alone.

MS has added a lot to it since then, no doubt. They've also developed a lot of nice administration tools, which is probably their smartest move. Especially 10 years ago, when properly administering an Oracle database required a DBA with deep knowledge of command line tools, config files, and Oracle internals --- and a high five to six figure salary --- whereas SQL Server even then was all point and click.

Re:PostgreSQL vs SQL Server installation Faceoff by rbanffy on Monday May 31, 2010 @11:16AM (#1392657)
I remember when MS SQL and Sybase were the same. MS SQL Server improved a whole lot since then. It's improvement could stand alone as Microsoft greatest software accomplishment - it's really improvement, not only feature bloat.

As for point-and-click vs deep understanding of what's going on, I'll go with the deep understanding. If I am going to trust my company's data to a machine, I want it to have a smart human caring for it.

Re:PostgreSQL vs SQL Server installation Faceoff by ergo98 on Monday May 31, 2010 @11:30AM (#1392689)
>SQL Server is (was) Sybase

Way back at SQL Server 7 it had dramatically diverged from its roots. SQL Server 6.5 was really the only Sybase-like version.

Re:PostgreSQL vs SQL Server installation Faceoff by viraptor on Monday May 31, 2010 @11:21AM (#1392672)
Ah - frames make sense - I've never seen them included in a normal timer before.

I'm not suggesting that SQL server itself was designed to run years, but I hope that your database as a whole was. Of course you have to restart a single server sometimes, but most serious databases will be designed to stay up during that time via clustering / replication / whatever your solution is.

Re:PostgreSQL vs SQL Server installation Faceoff by rbanffy on Monday May 31, 2010 @05:10PM (#1393504)
It's a very common timing scheme in video. It just makes sense to count frames from the seconds than fractions of a second (that would be a pain to translate into frames).